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

Write an sql query to select all records from the table?

1079

what is normalization? : Sql dba

1137

What is trigger explain with example?

1092

Define tables and fields in a database

1177

What is a database event trigger?

1211

What is the difference between the conventional and direct path loader? : aql loader

1194

Explain what is dbms?

1120

How do I install sql?

1045

how many triggers are allowed in mysql table? : Sql dba

1103

What is the max nvarchar size?

1029

What is the purpose of the sql select top clause?

1206

What is pragma in pl sql?

1185

What is a sql*loader control file?

1344

What is the primary use of normalization?

1053

How do I add a primary key to a table?

1083