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 blob? : Sql dba

0 Answers  

What are primary key and foreign key and how they work?

0 Answers  

What is trigger point?

0 Answers  

How do I create a memory optimized filegroup?

0 Answers  

how to increment dates by 1 in mysql? : Sql dba

0 Answers  




What is sql entity?

0 Answers  

What is union and union all keyword in sql?

0 Answers  

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

when MSQL8.0 is in market

0 Answers  

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

what is the different between now() and current_date()? : Sql dba

0 Answers  

What is record variable?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories