with temp as (select * from emp order by rownum desc) select * from tem

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

Question Posted / pallavi v

Answer Posted / pallavi v

with temp as
(select * from emp order by rownum desc)
select * from temp where rownum < = 10

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the types of join and explain each? : Sql dba

1043

What is scalar function?

1058

Is a view faster than a stored procedure?

976

does sql support programming? : Sql dba

1052

What is pl sql code?

1060

How can get second highest salary in sql?

995

What is information schema in sql?

1078

Is left join and outer join same?

1077

What are the different types of dbmss?

1015

How do you create a unique index?

1051

How to select all records from the table?

1141

What is scope of pl sql developer in future?

1027

Which tcp/ip port does sql server run?

1015

Does truncate need commit?

951

Enlist the advantages of sql.

1006