SELECT ROWNUM, E1.* FROM ( SELECT * FROM Emp ORDER BY ROWNUM DESC )E1

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

Question Posted / swastik

12 Answers
27452 Views
iNautix, I also Faced
E-Mail Answers

Answer Posted / swastik

SELECT ROWNUM, E1.*
FROM
(
SELECT * FROM Emp
ORDER BY ROWNUM DESC
)E1
WHERE ROWNUM <= 10

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is your daily office routine?

2345

What is the best sql course?

1050

What is the current version of sql?

1092

how to start mysql server? : Sql dba

1266

Is primary key always clustered index?

1094

Does group by remove duplicates?

1112

What is the current version of postgresql?

1177

Can delete statement be rollbacked?

1053

how many tables will create when we create table, what are they? : Sql dba

1144

Can we rollback truncate?

1074

what is schema? : Sql dba

1146

what are aggregate and scalar functions? : Sql dba

1128

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2090

how to escape special characters in sql statements? : Sql dba

1113

how to use regular expression in pattern match conditions? : Sql dba

1112