how u can find the n row from a table?

Answer Posted / manish singhania

select * from emp where rownum<=n
minus
select * from emp where rownum<n

n=1,2,......so many

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write an sql query to select all records from the table?

555


Can we use distinct and group by together?

586


Explain the update statement in sql

560


what are enums used for in mysql? : Sql dba

610


What is left inner join in sql?

517






What is the difference between inner join and left join?

541


Define the select into statement.

568


What is the best free sql database?

564


What is the use of sqlerrd 3?

519


What is the purpose of primary key?

529


What is indexes?

540


What is nested table in pl sql?

553


How can you create an empty table from an existing table?

594


What is scalar function?

567


what is a primary key? : Sql dba

552