How do you retrieve the last N records from a table?
Answer Posted / nani
select * from emp a where &N > (select count(*) from emp b
where b.rowid > a.rowid)
N = No.of rows.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
how would you get the current date in mysql? : Sql dba
What are sql queries used for?
What is difference between sql and oracle?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
how to increment dates by 1 in mysql? : Sql dba
How do I start sql from command line?
What is trigger types in sql?
What is sqlexception in java?
Can sql function call stored procedure?
How does postgresql compare to mysql?
What is %s in sql?
Is mariadb a nosql database?
What is sql performance tuning?
how to create a table index in mysql? : Sql dba
Define sql delete statement.