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

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

Please Help Members By Posting Answers For Below Questions

Is sql a programming?

980

Does sql view stored data?

963

What is difference between primary and secondary key?

1033

What is mutating error?

973

Advantages and disadvantages of stored procedure?

1123

Does a primary key have to be a number?

969

Is sql a backend language?

1100

How do I view output in sql developer?

1089

What is sap sql?

989

What is synchronized subquery?

1173

Can we join same table in sql?

1032

What is primary key and foreign key?

966

What is the usage of sql functions?

1150

What's the difference between inner join and left join?

1005

What is the benefit of foreign key?

1023