select * from <table name> where rownum<=2 order by last

write a query find which rows of a table is updated on 2
days before?

Question Posted / os reddy

Answer Posted / os reddy

select * from <table name>
where rownum<=2
order by last_updated_date;

OR

select * from emp where to_char(update_column,'dd')=2;

Is This Answer Correct ?

3 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What are the possible values that can be stored in a boolean data field?

949

What is the difference between Union and Union all. Which is faster.

1342

Which is faster joins or subqueries?

931

Why do we need cursor in pl sql?

1080

What is the need of merge statement?

989

how do you tune the slow running queries in oracle db , explain the methodology

2072

What are the types of functions in sql?

968

What are sql functions? Describe the different types of sql functions?

1059

How do you define a foreign key?

941

What is sql and its types?

1114

Why self join is used in sql?

919

Why schema is used in sql?

987

How do I view a sql trace file?

961

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1161

What can you do with pl sql?

1034