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 sql and also describe types of sql statements?

1020

What is the life of an sql statement?

982

What are the different tcl commands in sql?

1123

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

951

Which type of cursor is used to execute the dml statement?

912

What is fmtonly in sql?

1031

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

918

What is range partitioning?

918

Is there a way to automate sql execution from the command-line, batch job or shell script?

942

Is coalesce faster than isnull?

920

How do you run a query?

971

How do I use google cloud in sql?

1053

What is sql in oracle?

1022

Why we use stored procedure instead of query?

968

What is integrity in sql?

998