select * from <table name> where rownum<=2 order by last

in table there r so many rows write a query which two rows r
updated last two day befor?

Question Posted / srinivas

Answer Posted / srinivas

select * from <table name>
where rownum<=2
order by last_updated_date

Is This Answer Correct ?

29 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How do rank () and dense_rank () differ?

1044

Does sap use sql?

993

What is the difference between stored procedure and view?

1017

what are myisam tables? : Sql dba

1032

what are tables and fields? : Sql dba

1055

How do you copy a table in sql?

1069

What is bind reference and how can it be created?

1020

How can you create an empty table from an existing table?

1079

What is the main reason behind using an index?

1017

What does (*) mean in sql?

950

What is the process of copying data from table a to table b?

1091

Why truncate is faster than delete?

1109

What is cte sql?

994

Where not exists in sql?

979

What are triggers and its types?

1062