493 views

3 Answers

Best answer
1 votes
1 votes

I dont see any flaw with this.It should work.

https://www.w3schools.com/SQL/trysql.asp?filename=trysql_select_all

I ran :-    SELECT CustomerName as Customers FROM Customers;

Output:-

Number of Records: 5

Customers
Alfreds Futterkiste
Ana Trujillo Emparedados y helados
Antonio Moreno Taquería
Around the Horn
Berglunds snabbköp
selected by
1 votes
1 votes

It does not matter that ATTRIBUTE_NAME is same as TABLE_NAME or not. It works the same as before.

0 votes
0 votes
Yes, there is no problem in giving the name of attribute same as table name.

Related questions

0 votes
0 votes
1 answer
3
rayhanrjt asked Jan 6, 2023
717 views
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
2 votes
2 votes
1 answer
4
Subhrangsu asked Jun 18, 2022
431 views
Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)