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

Which is better cte or subquery?

970

How can we avoid duplicating records in a query?

921

What is %type in pl sql?

923

How many triggers can be applied to a table?

992

how to use like conditions? : Sql dba

1036

What does 0 mean in sql?

910

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

943

Is pl sql a programming language?

923

What does select count (*) mean in sql?

960

What does the base_object_type column shows in the user.triggers data dictionary view?

994

How many parts of a pl sql block are optional?

1029

Why do we go for stored procedures?

993

what is a trigger in mysql? Define different types of trigger. : Sql dba

1009

what is sql in mysql? : Sql dba

1120

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

993