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
- 7874 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 are constraints in microsoft sql server?
Differentiate between ms sql server reporting services vs crystal reports?
What is cube dimension? : sql server analysis services, ssas
How retrieve field names from the table in SQL through JAVA code?
What are the dis_advantages of stored procedures, triggers, indexes?
What is sql injection and why is it a problem? : sql server security
Difference between Sql server reporting services and Crystal reports?
What is replication with database mirroring? : sql server database administration
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Can a table be moved to different filegroup?
What the class forname () does?
Tell me what is the difference between locking and multi-versioning?
Do I need a report server to run reports in my application?
Tell me what is a linked server?
what are the three command line utilities and what are their primary functions?
