select empid empname from employee
What is the result for the about query?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kalyana chakravarthy maddipati
There should be a , between empid and empname like empid,empname if not empname will be taken as Alias name for empid ie, all the results empid will be displayed with a column heading as empname
Is This Answer Correct ? | 1 Yes | 0 No |
What is a DBMS, query, SQL?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are the 10 characteristics of data quality?
Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s
What are “phantom rows”?
Do you know nested transaction?
Why are sql functions used?
Why is replication required on the sql server?
What is lock escalation?
What is xdr?
What is the use of “join” in sql server?
What is the difference between coalesce() & isnull()?