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

How do I create a memory optimized filegroup?

1012

What is sql integrity?

1248

What is vector point function?

1097

How do you write an inner join query?

996

Is stored procedure faster than query?

1021

what is the syntax for using sql_variant_property? : Transact sql

1086

When are we going to use truncate and delete?

1024

Why do we use function in pl sql?

1114

What are the three forms of normalization?

1093

What is program debugging?

1345

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1088

What are local and global Indexes and where they are useful.

1495

how to select first 5 records from a table? : Sql dba

1029

what is oltp (online transaction processing)? : Sql dba

1129

What is the difference between distinct and unique in sql?

993