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 is a field in a database ? : Sql dba

1041

What is set transaction?

1018

What is the use of pl/sql table?

1045

How run sql*plus commands that are stored in a local file?

1035

What are all ddl commands?

1065

How many sql commands are there?

1102

What is a pragma statement?

1249

What is right join in sql?

1075

What is difference between sql and oracle?

1096

what happens if null values are involved in expressions? : Sql dba

1026

what are date and time data types in mysql? : Sql dba

953

How do you declare a constant?

945

what is 'mysqldump'? : Sql dba

1092

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1035

What is a database? Explain

1092