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 are the types of variables use in pl sql?

1044

what are the properties and different types of sub-queries? : Sql dba

1034

How to raise user-defined exception with custom sqlerrm ?

1131

how to create a new table by selecting rows from another table in mysql? : Sql dba

1107

what are the differences between char and varchar? : Sql dba

1076

What is sap sql?

988

What is sql mysql pl sql oracle?

1075

What are field types?

1008

What is varray in pl sql?

1079

Which language is used in sql?

1064

How does index help in query performance?

1031

Which is better varchar or nvarchar?

999

Can we use threading in pl/sql?

1043

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1159

How do I save a stored procedure?

1011