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


Please Help Members By Posting Answers For Below Questions

What is trigger explain it?

740


Is sqlite good enough for production?

734


What is the difference between a query and a report?

680


What are the two parts of design view?

770


Can a key be both primary and foreign?

718






What is a database trigger?

791


How can you know that statistics should be updated?

799


How to use distinct and count in sql query? Explain

765


What is procedure and function in sql?

744


Why functions are used in sql?

703


Which are the different case manipulation functions in sql?

734


What is varchar data type in sql?

715


How to write a query to show the details of a student from students table whose

755


Which function is used to return remainder in a division operator in sql?

786


How to get help at the sql prompt?

831