select * from last10 minus select * from last10 where row >= (select

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

Question Posted / akshaya

12 Answers
26781 Views
iNautix, I also Faced
E-Mail Answers

Answer Posted / akshaya

select * from last10
minus
select * from last10
where row >= (select COUNT(*)-10 from last10)

condition should be >= not <=
for all the above queries

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to calculate expressions with sql statements? : Sql dba

1032

What are pl sql data types?

1007

Is sql better than excel?

1144

How many times can we commit in a loop?

1012

What is the difference between null value, zero, and blank space?

1196

How to set up sql*plus output format in oracle?

1032

What is sap sql anywhere?

1066

discuss about myisam key cache. : Sql dba

1019

What is cursor in pl sql?

1114

How many tables can you join in sql?

955

what is the difference between undefined value and null value? : Sql dba

1095

What is a pdo connection?

1025

Can we write dml inside a function in sql server?

941

What is pls integer?

1032

What is the difference between join and natural join?

927