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 two virtual tables available at the time of database trigger execution?
Is left join faster than inner join?
What is number function in sql?
What is the use of pl/sql table?
What is the difference between mdf and ndf files?
Can we insert in sql function?
What is the difference between pl and sql?
How can you load microsoft excel data into oracle? : aql loader
how to convert dates to character strings? : Sql dba
What are all the different normalizations?
Name the operator which is used in the query for pattern matching?
Why is sql*loader direct path so fast?
what are the advantages a stored procedure? : Sql dba
What are the properties of a transaction?
how to add a new column to an existing table in mysql? : Sql dba