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

Does inner join return duplicate rows?

978

What is cursor and why it is required?

1183

how to present a past time in hours, minutes and seconds? : Sql dba

1013

what are all types of user defined functions? : Sql dba

1042

What is nvarchar max in sql?

1019

What is Histogram?

1560

Can we have two clustered index on a table?

1025

What is trigger in pl sql?

1003

how to add a new column to an existing table in mysql? : Sql dba

1073

How do you declare a user-defined exception?

1025

What is cte sql?

998

Explain what is a database?

1087

how to enter binary numbers in sql statements? : Sql dba

974

Can function return multiple values in sql?

1061

What is aggregate function in sql?

1040