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 does cursor do in sql?

1067

What are the different dml commands in sql?

1247

How many types of relationship are there?

1082

What is clause?

1228

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1247

What is dml statement?

999

Does mysql support pl sql?

1230

How do you update sql?

1036

What is the purpose of normalization?

1086

What is an escape character in sql?

1071

Can we join 3 tables in sql?

1107

What are %type and %rowtype for?

1106

What is difference between sql and excel?

1176

What is Materialized View? In What Scenario we Use Materialized View?

9616

What are % type and % rowtype?

1081