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

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

Question Posted / chandrakishan

Answer Posted / chandrakishan

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

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do I run a pl sql program?

1128

How to select unique records from a table?

1055

How to display the current date in sql?

1075

Is sql a backend language?

1092

Can we create clustered index without primary key?

962

What are the ways on commenting in a pl/sql code?

1133

How does cross join work?

951

What is the best sql course?

983

How do I make sql search faster?

995

What is java sql driver?

1117

Are subqueries better than joins?

974

Is sql easier than java?

1010

What is minus?

988

What is pl sql quora?

1154

What is cursor and why it is required?

1183