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                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories >> Software >> Databases >> SQL-Server
 
 
 
Question
can anybody tell us, how to select 2nd max salary from 
table.
my id is ashish.akk@gmail.com
 Question Submitted By :: Ashish
I also faced this Question!!     Rank Answer Posted By  
 
Answer
I think Daleep answer is not so precise, if you want 3rd or 
ny specified answer, this only can only be seems right for 
2nd highest salary, else, its not optimise query.I found 
Preeti's query more optimistic and accurate.
 
0
Neeru
 
View All Answers
 
 
 
 
 
   
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