select * from <TN> minus select * from <TN> where rownum &l

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

Question Posted / siddharthapenchala

Answer Posted / siddharthapenchala

select * from <TN>
minus
select * from <TN>
where
rownum <= (select count(*) - &n from <TN>)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is trigger point?

1056

Do we need to rebuild index after truncate?

1097

What is the difference between function, procedure and package in pl/sql?

1349

What is data types in sql?

1070

What are the different operators available in sql?

1057

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3619

What is difference between nchar and nvarchar?

1098

How to select 10 records from a table?

1205

What is the order of sql select?

1086

What is sql keyword?

1043

What is sql profiler in oracle?

1158

Can we use ddl commands in pl sql?

1227

What is the usage of when clause in trigger?

1087

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1007

What is the left table in sql?

1013