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 are the different functions in sorting an array? : Sql dba

595

Is sql a backend?

566

Is primary key is clustered index?

539

Why are indexes and views important to an organization?

535

How can a function retun more than one value in oracle with proper example?

598

Is sql between inclusive?

613

Is sql easier than java?

541

What is dynamic sql in pl sql?

509

Mention what are different methods to trace the pl/sql code?

572

how to convert numeric values to character strings? : Sql dba

581

Is inner join faster than left join?

652

What does select * from mean in sql?

2040

what is single byte over head in oracle..?

1884

define join and explain different type of joins? : Sql dba

564

How can you save or place your msg in a table?

535