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 the unique index?

1052

What are different types of queries in sql?

1114

How many types of privileges are available in sql?

1339

Is sql harder than python?

1093

What is the maximum number of columns in sql table?

1167

What is a relationship and what are they?

1142

How do I run a pl sql procedure in sql developer?

966

what is an index? : Sql dba

987

What are the main features of cursor?

1071

how do you know the version of your mysql server? : Sql dba

1000

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1214

What is sql*loader and what is it used for?

1140

Why are sql stored procedures used?

1052

How exception handling is done in advance pl/sql?

979

What is benefit of creating memory optimized table?

968