Find out the 3rd highest salary?
- 51 Answers
- 61859 Views
- BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
- E-Mail Answers
Answer Posted / karna
Hi Friends,
sorry,last answer was wrong.
I have changed the query,check now
to get the nth highest value of a column in a table,please
use the below simple query
select min(column) from table where column in(select top n
column from table order by desc)
any queries,mail me at karun84@gmail.com
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
Does mysql_real_escape_string prevent sql injection?
How to display the records between two range in Oracle SQL Plus?
Write the alter statement to enable all the triggers on the t.students table.
What are the steps for performance tuning.
Define overloaded procedure?
When to use inner join and left join?
What is an implicit commit?
How many sql commands are there?
What are the basic sql commands?
What type of join is sql join?
What is left join example?
Does oracle use sql?
What is synonyms?
Which command is used to delete a trigger?
What is rename in sql?
