select empid empname from employee What is the result for the about query?

select empid empname from employee

What is the result for the about query?

Question Posted / senthilsjc

4 Answers
6081 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

select empid empname from employee What is the result for the about query?..

Answer / vinayak

select empid,empname from employee

Is This Answer Correct ?

3 Yes

1 No

select empid empname from employee What is the result for the about query?..

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

select empid empname from employee What is the result for the about query?..

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

select empid empname from employee What is the result for the about query?..

Answer / guest

itis dis[lay

Is This Answer Correct ?

0 Yes

2 No

Post New Answer