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

how to select first 5 records from a table? : Sql dba

595

What are the key differences between SQL and PL SQL?

730

What will you get by the cursor attribute sql%notfound?

688

How many types of cursors supported in pl/sql?

696

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

616

how to enter binary numbers in sql statements? : Sql dba

586

What does desc stand for?

688

What is sql and how does it work?

638

What is the command used to fetch the first 5 characters of a string?

819

Can %notfound return null after a fetch?

677

What is a null value?

726

What are the two types of exceptions.

720

What is natural join in sql?

621

What does count (*) do in sql?

633

How do I view a view in sql?

599