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

What is consistency?

886


What are local and global variables and their differences?

810


What are different types of queries in sql?

733


what is the difference between truncate and drop statements? : Sql dba

744


What is the use of triggers?

738






explain about mysql and its features. : Sql dba

742


what is the difference between inner and outer join? Explain with example. : Sql dba

728


What are properties of the transaction?

724


What is replication id?

683


How do you update a sql procedure?

766


what is the difference between undefined value and null value? : Sql dba

779


What is transaction control language (tcl)?

849


How to place comments in pl/sql?

797


Write a sql query to convert all character to uppercase after hypen.

1167


how to enter binary numbers in sql statements? : Sql dba

706