how to check the 3rd max salary from an employee table?
Answer Posted / ar
select c.emp_id,c.salary from (select rownum as
rn1,c.emp_id,c.salary from (select * from table_name ORDER
by salary DESC) b) c
where c.rn1 = n --(n=3)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to select first 5 records from a table? : Sql dba
how to load data files into tables with 'mysqlimport'? : Sql dba
Explain what is rdbms?
What kind of join is join?
Does asenumerable execute the query?
what are the different type of sql's statements ? : Sql dba
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How do I get sql certification?
what is the syntax for using sql_variant_property? : Transact sql
How many types of primary keys are there?
What is sql partition function?
Write a unique difference between a function and a stored procedure.
explain the advantages and disadvantages of stored procedure? : Sql dba
What are different categories of sql commands?
How much does sql certification cost?