Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

select empid empname from employee

What is the result for the about query?

Question Posted / senthilsjc

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

More SQL Server Interview Questions

Explain indexing and what are the advantages of it?

0 Answers  

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

What is the language structure to add a record to a table?

0 Answers  

What is a db view?

0 Answers  

What is extended stored procedures?

0 Answers  

What is difference between index seek vs. Index scan?

0 Answers  

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

What are the advantages dts has over bcp?

0 Answers  

If no size is defined while creating the database, what size will the database have?

0 Answers  

Explain what is row_number function?

0 Answers  

Is port 1433 secure?

0 Answers  

What have included columns when we talk about sql server indexing?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories