can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / neeru
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.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many triggers are possible per table?
What is data source object?
Write a query for primary key constraint with identity key word?
What is the difference function and stored procedure?
Do you know what is a linked server in sql server?
What is cursor in ms sql server?
How to use subqueries with the exists operators in ms sql server?
What is merge join?
What is usually the first word in a sql query?
What is parameterized reports in ssrs ?
How to drop an existing table?
Explain cursor as data base object?
How do we synchronize On-Premise SQL server with SQL Azure?
Why use “pivot” in sql server?
Explain mixed authentication mode of sql server?