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
- 7513 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
Write a code to select distinct records without using the DISTINCT keyword.
How can we remove orphan records from a table?
How to download and install sql server 2005 books online?
what is sql server? : Sql server database administration
How to drop an existing stored procedure in ms sql server?
What is BCP? When does it used in sql server 2012?
How many types of the database links?
What happens if strings are casted into wrong code pages in ms sql server?
What is the maximum length of an alert name?
What are the different types of subquery?
How to select true false based on column value in sql server?
what is hash nonclustered index
A trigger can reference objects outside the current database? State true or false.
What is the difference between functions and stored procedures?
Define ACID properties in a Database?
