can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / kumar amit ranjan
To find Top 3 max Sal.... to put any number on the place of
3 to find nth max sal...
select top 3 sal from emp order by sal desc
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain the flow of creating a cube? : sql server analysis services, ssas
What is default port number for sql server 2000?
What are transactions in sql?
Tell me about normalization in DBMS.
What new data source types were added in ssrs 2014?
What is best institute to Learn DotNET And SQL in chennai?
What is encryption key?
What is normalization and denormalization in sql server?
What is a non clustered primary key?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What are the new scripting capabilities of ssms? : sql server management studio
What is the recovery model?
What are the three different part of rdl file explain them?
How is SQL Azure different than SQL server?
What is the main difference between ‘between’ and ‘in’ condition operators?