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 oracle pl sql developer?

942

What will you get by the cursor attribute sql%notfound?

1026

Can you have more than one trigger on a table?

953

What is the difference between having and a where in sql?

1045

What is the difference between left join and right join?

900

Can %notfound return null after a fetch?

1016

What is union, minus and interact commands?

1230

can sql servers linked to other servers like oracle? : Sql dba

968

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3016

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1108

What is pl sql package?

999

What is parallel hint?

1236

What is the left table in sql?

923

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

1309

is mysql query is case sensitive? : Sql dba

1043