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 are different joins used in sql?

1010

what is rdbms? : Sql dba

962

How many joins can you have in sql?

881

What is trigger types of trigger?

996

what is auto increment? : Sql dba

965

What are the different types of sql commands?

1065

Can we use ddl commands in pl sql?

1075

Is and as keyword in pl sql?

908

What are basic techniques of indexing?

1325

Can you inner join the same table?

938

what is collation? : Sql dba

1079

How can you tell the difference between an index and a view?

872

What is varchar example?

975

Can there be more than one function with a similar name in a pl/sql block?

927

Whis is not false in primary key?

1406