select * from emp minus select * from emp where rownum<= (select count(

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

Question Posted / hussain

Answer Posted / hussain

select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Why is partition used in sql?

552

What is union, minus and interact commands?

750

Is join an inner join?

540

i have some prob lem to tell me about my self in interview first round ...

1709

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

535

What is the difference between nested table and varray?

525

What is case function?

603

What are the rules to be applied to nulls whilst doing comparisons?

756

how to start mysql server? : Sql dba

617

Is sql scripting language?

528

What is the difference between inner join and outer join?

537

What happens when a trigger is associated to a view?

508

What is trigger types of trigger?

556

How to Execute a Package in PL/SQL.?

589

Explain about various levels of constraint.

525