Interested to Buy Any Domain ? << Click Here >> for more details...
select empid empname from employee
What is the result for the about query?
- 4 Answers
- 7650 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
It will give the empids list from the table, with column
name as empname.
This implies the general syntax of renaming a column when
retriving data.
syntax: select dbcolumnname as newcolumnname from table1
OR
select dbcolumnname newcolumnname from table1.
Both the statements means the same.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is shared lock?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How do you delete a trigger?
What are the difference between clustered and a non-clustered index?
What is the process of normalising?
How can we determine what objects a user-defined function depends upon?
What is unpivot?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is the difference between online clustering and Offline clustering?
How to identify current user in ssrs report?
How many joins in sql server?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is the use of keyword with encryption. Create a store procedure with encryption?
How can sql injection be stopped? : sql server security
How to modify an existing stored procedure in ms sql server?
