I want to know last five transactions or records from emp
table, from now?
Answer Posted / thulasi reddy
select * from emp minus(selecet * from emp where
rownum<(select count(*)_4 from emp))
this will give last records
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is trigger explain it?
Is sqlite good enough for production?
What is the difference between a query and a report?
What are the two parts of design view?
Can a key be both primary and foreign?
What is a database trigger?
How can you know that statistics should be updated?
How to use distinct and count in sql query? Explain
What is procedure and function in sql?
Why functions are used in sql?
Which are the different case manipulation functions in sql?
What is varchar data type in sql?
How to write a query to show the details of a student from students table whose
Which function is used to return remainder in a division operator in sql?
How to get help at the sql prompt?