Find out the 3rd highest salary?
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 the different type of sql's statements ? : Sql dba
What is the difference between left and left outer join?
List the ways to get the count of records in a table?
What is the difference between inner join and left join?
What is rownum?
Explain the the delete statements in sql?
What does an inner join do?
how can we know the count/number of elements of an array? : Sql dba
What is trigger explain it?
What does desc stand for?
what are ddl statements in mysql? : Sql dba
What is group by in sql?
What is the difference between clustered and non-clustered index in sql?
Which is better varchar or nvarchar?
What is a stored procedure in sql with example?