ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
select empid empname from employee

What is the result for the about query?
 Question Submitted By :: Senthilsjc
I also faced this Question!!     Rank Answer Posted By  
 
  Re: select empid empname from employee What is the result for the about query?
Answer
# 1		 
itis dis[lay
 
Is This Answer Correct ?    0 Yes 1 No
Guest
 
  Re: select empid empname from employee What is the result for the about query?
Answer
# 2		 
select empid,empname from employee
 
Is This Answer Correct ?    1 Yes 1 No
Vinayak
 
 
 
  Re: select empid empname from employee What is the result for the about query?
Answer
# 3		 
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 ?    2 Yes 1 No
Swetha
 
  Re: select empid empname from employee What is the result for the about query?
Answer
# 4		 
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 ?    0 Yes 0 No
Kalyana Chakravarthy Maddipati
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename> 247Customer2
how to select 5 to 7 rows from a table, which contains 10 rows? IBM14
What are the types of indexes available with SQL Server?  2
What's the difference between a primary key and a unique key? Wipro8
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?  1
How do you troubleshoot SQL Server if its running very slow?  2
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.  5
Can you explain the types of Joins that we can have with Sql Server?  2
how to delete duplicate rows from table in sql server HCL8
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  3
what is Archive old data?  1
how to count datewise data in sqlserver IndusInd-Bank3
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"  1
what is bit data type? and what are the information that can be stored inside a bit column?  2
can you any body tell me suppose database is suspect mode. how can take to normal? Teledata1
what are the joins,primary key,foriegn key, candidate key, super key and expain them? Polaris2
What are the different types of backup avaible in SQL SErver Emphasis5
What is the difference between having and where clause?  4
how do u do Performance tunning ? Satyam1
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com