how u can find the n row from a table?

Answer Posted / monika

select employee_id,last_name,salary
from employees
where rownum < n
ORDER by salary

Is This Answer Correct ?    0 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is insert command in sql?

530


Which certification is best for sql?

544


how to fetch common records from two tables? : Sql dba

633


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

545


What is the use of stored procedures?

519






What is scope of pl sql developer in future?

595


Which is better join or inner query?

522


What is form and report?

521


What is record type in pl sql?

552


What is nosql example?

585


What is meant by <> in sql?

511


Can we join 3 tables in sql?

501


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2578


Can a composite key be null?

532


What is output spooling in sql*plus?

557