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 data control language? : Sql dba

590

What are the set operators in sql?

562

Does mysql support pl sql?

627

How long it takes to learn pl sql?

535

What is a database? Explain

598

What is mdb stand for?

560

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

8541

Can we rename a column in the output of sql query?

545

What version is sql?

555

What is view? Can we update view

867

What are the types of optimization?

523

what is the difference between char and varchar data types? : Sql dba

543

Which table is left in join?

520

Can we create index on primary key?

528

What is sql indexing?

557