Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nripesh agarwal
select * from emp where salary=(select distinct salary from
emp order by salary desc limit n,1)
// for Nth highest value put n=N-1....
//for 3rd highest put n=2........
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
how can we find the number of rows in a table using mysql? : Sql dba
what is commit? : Sql dba
What is form and report?
define sql insert statement ? : Sql dba
Is sql harder than python?
What is use of package in pl sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Why cross join is used?
What is a table in a database?
What is column?
What are tables in sql?
what is self-join? : Sql dba
What is a delimiter in sas?
What is a heap in sql?
What are inner and outer joins examples of both?
