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
- 7704 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 happens if time-only values are provided as date and time literals?
What is normalization and denormalization in sql server?
what is package and it uses and how can u call a package
Can group functions be used in the order by clause in ms sql server?
What is an expression in ms sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Can sql servers link to other servers?
how many bits ip address consist of? : Sql server database administration
Explain the categories of stored procedure?
Which language rdl files made of?
How to connect Azure federated root database and apply federation in entity framework?
Find first and last day of current month in sql server
What is a result set object returned by mssql_query()?
Where in ms sql server is ’100’ equal to ‘0’?
Do you know what is lock escalation?
