SELECT RN, Ename FROM ( SELECT Rownum RN, Ename FROM Emp ) WHER

How do you retrieve the last N records from a table?

Question Posted / ajit

Answer Posted / ajit

SELECT RN, Ename
FROM ( SELECT Rownum RN, Ename
FROM Emp )
WHERE RN = &Grecno;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is not equal in sql?

1064

What is the difference between partition and index?

1062

What is the difference between a primary key and a unique key?

1108

Is sql scripting language?

1115

What is denormalization in a database?

1107

What is set serveroutput on in pl sql?

1362

Explain the uses of a database trigger?

1089

Explain the commit statement.

1215

Explain the difference between drop and truncate commands in sql?

1114

What does fetching a cursor do?

1134

how to get a list of all tables in a database? : Sql dba

1031

What are three advantages to using sql?

1072

What is procedure explain with program?

1068

Which sql most popular?

1031

How do I pipe the output of one isql to another?

1058