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

what is the difference between char_length and length? : Sql dba

0 Answers  

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

What is range partitioning?

0 Answers  

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

What is exit statement?

0 Answers  




What has stored procedures in sql and how we can use it?

0 Answers  

What is a dirty read sql?

0 Answers  

What is group function in sql?

0 Answers  

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

What is the difference between distinct and unique in sql?

0 Answers  

how to create a new table by selecting rows from another table in mysql? : Sql dba

0 Answers  

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

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories