select empno from (select empno from emp order by empno desc) where rownu

Write a query to get last 10 records from the table.

Question Posted / praveen biradar

Answer Posted / praveen biradar

select empno from (select empno from emp order by empno
desc) where rownum<=10 order by empno

Is This Answer Correct ?

10 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What does closing a cursor do?

1243

explain access control lists. : Sql dba

946

What is t-sql? : Transact sql

925

What is difference between inner join and self join?

1028

What is scope of pl sql developer in future?

948

Explain sql data types?

1034

what is not null constraint? : Sql dba

963

Is sql open source?

914

what is blob? : Sql dba

1054

How do you select unique values in sql?

934

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3007

How does stored procedure reduce network traffic?

965

Can a key be both primary and foreign?

943

What is dense_rank in sql?

915

What are dml commands?

938