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 an index? What are the types of indexes? How many clustered indexes can be created on a table?

722

What is union and union all keyword in sql?

724

what is a foreign key ? : Sql dba

789

Should I use mbr or gpt?

727

What is user in sql?

764

How do you create a db file?

712

What is assignment operator in pl sql?

764

How do you update a sql procedure?

768

Can we call procedure in select statement?

732

What is cascade in sql?

704

What is difference between inner join and self join?

782

What is a natural join sql?

706

What does (+) mean in sql joins?

739

What is rowtype?

767

What is use of package in pl sql?

713