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

Does mysql_real_escape_string prevent sql injection?

916

How do you know if a relationship is 2nf?

895

what are the limitations of identity column? : Transact sql

1066

Why are sql stored procedures used?

1013

How do I pipe the output of one isql to another?

959

What is clause in sql?

1072

Explain what is sql?

1079

How do I make sql search faster?

956

What are procedures used for?

936

What is AUTH_ID and AUTH_USER in pl/sql ?

2149

How many parts of a pl sql block are optional?

1058

What is rownum in sql?

990

What is a recursive join sql?

1039

What kind of join is join?

919

Can a table have no primary key?

1021