select * from emp minus(selecet * from emp where rownum<(select count(*

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

Question Posted / thulasi reddy

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

Please Help Members By Posting Answers For Below Questions

What is the use of stored procedures?

1053

How do you delete a table?

1082

What is dba in sql? : SQL DBA

1045

Show how functions and procedures are called in a pl/sql block.

1130

What is pl sql block structure?

1044

How can we optimize a sql query?

1053

What does cursor do in sql?

1029

Why do we need a foreign key?

1102

Is it possible to update views?

961

State few characteristics of pl/sql?

971

Explain the significance of the & and && operators in pl sql.

1009

What are the different types of dbmss?

1015

Is there a way to automate sql execution from the command-line, batch job or shell script?

976

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1193

What is number function in sql?

980