select * from emp minus select * from emp where rownum<= (select count(

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

Question Posted / hussain

Answer Posted / hussain

select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the command used to fetch first 5 characters of the string?

1463

how to calculate the difference between two dates? : Sql dba

1112

What is the difference between database trigger and stored procedure?

1136

How to start oracle sql developer?

1074

What is cross join sql?

964

What is offset in sql query?

1176

What is basic structure of pl sql?

1129

What is a temporal table?

980

What is the need of a partition key?

1027

What is the purpose of primary key?

1070

Is sql easier than java?

1069

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1011

What are the commands used in sql?

1130

Is sql a scripting language?

1082

What is java sql connection?

1120