Find out the 3rd highest salary?
- 51 Answers
- 66379 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
what are different types of keys in sql?
What is number function in sql?
What is the use of prepared statement?
What is information schema in sql?
what is the difference between truncate and drop statements? : Sql dba
what is timestamp in mysql? : Sql dba
How do I remove all records from a table?
Which normal form is best?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is an escape character in sql?
How many joins in sql?
Can we rollback after truncate?
what are wild cards used in database for pattern matching ? : Sql dba
What does := mean in pl sql?
Does access use sql?
