Tech for boost
This blog contain tech artical, interview preparation for .net, Angular, SQL, UML Diagram
Sunday, 4 May 2025
02 SQL alias based Query. SQL MCQ
SELECT * FROM Employee;
What will be output of below SQL Query ?
SELECT (FirstName +' ' + LastName) as FullName
FROM Employee
WHERE EmployeeID = 1;
Answer : Error
Reason of error:
When using aliase, it must be a single world.
Alliase
will not accept space
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment