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

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2414

Is sql a backend language?

1043

What is the trigger in sql?

905

Is trigger a stored procedure?

887

How to call shell script from pl sql procedure?

1177

What are the types of join and explain each?

989

Can we create a trigger on view?

844

Does truncate free space?

948

how to create a new view in mysql? : Sql dba

895

What is rollback?

1038

What does the acronym acid stand for in database management?

985

Does oracle roll back the transaction on an error?

963

How many types of triggers are there in pl sql?

1016

Is pl sql a programming language?

929

How do I save a sql query?

962