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
27188 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

what are the nonstandard string types? : Sql dba

1204

Why do we use %rowtype & %type in plsql?

1095

Can we use having without group by in sql?

1046

What is the usage of sql functions?

1200

Which are the different case manipulation functions in sql?

1075

Is pl sql a programming language?

1040

What version is sql?

1076

How to return multiple rows from the stored procedure?

1014

Where do we use pl sql?

1048

What is the default isolation level in sql server? : Transact sql

1080

What is trigger in pl sql?

1046

explain advantages of innodb over myisam. : Sql dba

1175

what is a constraint? Tell me about its various levels. : Sql dba

1044

What is a sql statement?

1016

What is rownum and rowid?

1075