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

How do you use join?

947

How many types of relationship are there?

1031

What is primary key and foreign key?

966

Is it possible to sort a column using a column alias?

1055

What are joins in sql?

1050

How to write html code in pl sql?

1119

How to Declare Fixed Length String Value In PL SQL

1158

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

1008

What are data types in pl sql?

1148

What does the hierarchical profiler does?

1065

List the different type of joins?

1061

Which is faster count (*) or count 1?

1038

How to Execute a Package in PL/SQL.?

1212

Should I use mbr or gpt?

1030

What is compiled query?

1042