Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / gouri sankar

Answers were Sorted based on User's Feedback



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

Answer / srinivas

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

Is This Answer Correct ?    29 Yes 6 No

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

Answer / ashok kumar lenka

We can solve this by the help of Trigger.
The trigger is for update.which store the update time of the
record of the table. So my query is like this
>select * from emp where to_char(update_column,'dd')=2;

Is This Answer Correct ?    10 Yes 5 No

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

Answer / narenkumar reddy

select column_name from table_name
where column_name=sysdate-2

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

How can use stored procedures in sql?

0 Answers  

What is the difference between union and union all command?

0 Answers  

how would concatenate strings in mysql? : Sql dba

0 Answers  

What is the difference between python and sql?

0 Answers  

what are ddl statements in mysql? : Sql dba

0 Answers  

Can you rollback after commit?

0 Answers  

How do I debug a stored procedure?

0 Answers  

What is sql and also describe types of sql statements?

0 Answers  

What is parameter substitution in sql?

0 Answers  

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

What are the parts of a sql statement?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories