SELECT * FROM emp e WHERE 1> (SELECT COUNT(1) FROM emp f WHERE

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

Question Posted / a g srikanth

Answer Posted / a g srikanth

SELECT *
FROM emp e
WHERE 1>
(SELECT COUNT(1) FROM emp f WHERE e.rowid<f.rowid
);

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is restrict in sql?

1035

What is the file extension for sql database?

939

how does a local variable is defined using t-sql? : Transact sql

950

how to fetch common records from two tables? : Sql dba

1108

what is the difference difference between procedure and packages

10252

what is the difference between a having clause and a where clause? : Sql dba

1009

What are the disadvantages of file system?

1165

How to add, remove, modify users using sql?

980

Why is there a need for sqlcode and sqlerrm variables?

999

What is dynamic query?

915

What is the difference between rollback and rollback to statements?

1015

Why is normalization important?

973

What are the key differences between SQL and PL SQL?

1149

What is the syntax and use of the coalesce function?

1100

How to return an array from java to pl/sql?

1063