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
26672 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 you improve the performance of sql*loader? : aql loader

997

What are the syntax and use of the coalesce function?

1179

How many sql statements are used?

999

How do I debug a stored procedure?

1093

What is having clause in sql?

946

What is secondary key?

917

What is the usage of when clause in trigger?

1031

does sql support programming? : Sql dba

1028

What is dcl in sql?

941

What is a crud api?

938

Is it possible to include an insert statement on the same table to which the trigger is assigned?

998

what is uncommittable transactions? : Transact sql

986

Is sqlite thread safe?

1031

How do I view a table in sql?

993

What are joins in sql?

1023