I want to know last five transactions or records from emp
table, from now?

Answer Posted / sarmistha

select TOP (5) * from emp order by empid desc

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you fetch first 5 characters of the string?

546


How do I access sql anywhere database?

495


What is a recursive stored procedure?

613


Why is sql better than hql?

503


what is a trigger in mysql? Define different types of trigger. : Sql dba

548






What is cte?

569


What are properties of the transaction?

554


Explain what is an index?

582


what is blob? : Sql dba

560


how to load data files into tables with 'mysqlimport'? : Sql dba

517


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

593


Can pl sql procedure have a return statement?

548


What is the difference between left and left outer join?

512


What is pl sql commands?

555


How many sql statements are used?

564