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
What is the purpose of normalization?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What port does sql server use?
Why query optimization is needed?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What are types of joins?
What is a behavioral trigger?
how many ways to get the current time? : Sql dba
What is the default isolation level in sql server? : Transact sql
how to enter binary numbers in sql statements? : Sql dba
What is pessimistic concurrency control? : Transact sql
What are all types of user defined functions?
What are the differences between in and exists clause?
When sql appeared?
what is the difference between undefined value and null value? : Sql dba