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

what is the syntax used for partition in tsql? : Transact sql

996

What are secondary keys?

955

What is a temporal data type?

1026

Describe different types of general function used in sql?

1016

How do I quit sql?

934

define sql insert statement ? : Sql dba

1009

What is rownum and rowid?

1018

what is the difference between delete and truncate statement in sql? : Sql dba

1210

What is lookup table in sql?

1018

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1080

Is delete faster than truncate?

993

Why is sharding used?

978

what are string data types? : Sql dba

1022

Can we insert in sql function?

1063

How do you bind variables in pl sql?

1073