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

12 Answers
26682 Views
iNautix, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are aggregate functions in sql?

1139

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1327

How much does a sql dba make? : SQL DBA

928

How to install oracle sql developer?

1021

What is self-join and what is the requirement of self-join?

1130

How to Declare Fixed Length String Value In PL SQL

1135

How do I run a sql script?

1121

What is the current version of sql?

1004

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2484

Define commit?

980

What are the uses of merge?

1151

What is a dynamic query?

1008

Why is sql better than hql?

970

How bulk collect improves performance?

984

How many types of functions are there in sql?

932