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

How many types of functions are there in sql?

1006

What are sql indexes?

1046

what is sp_pkeys? : Transact sql

1203

How do you know if a relationship is 2nf?

994

What is record in pl sql?

1140

How you improve the performance of sql*loader? : aql loader

1063

How can you know that statistics should be updated?

1128

What is a natural join sql?

1038

What is the order of sql select?

1088

What is the use of non clustered index?

1043

Write a query to find the names of users that begin with "um" in sql?

1044

Can we use pl sql in sql server?

1136

what are the differences between char and nchar? : Sql dba

1160

Is there a 64 bit version of ssms?

997

What is the purpose of design view?

1074