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 is mutating error?

972

What is a database? Explain

1116

What is raw datatype in sql?

1047

how tsql statements can be written and submitted to the database engine? : Transact sql

995

Explain the significance of the & and && operators in pl sql.

1009

What is informix sql?

983

What is java sql driver?

1129

Does db2 use sql?

951

How to run sql functions in pl/sql?

1058

Differentiate pl/sql and sql?

1071

How many types of cursors are available in pl/sql?

1111

What is the difference between microsoft access and sql?

1029

What are the 3 types of behavioral triggers?

1255

What is blind sql injection?

1079

how to extract a unit value from a date and time? : Sql dba

993