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

Answer Posted / narenkumar reddy

select column_name from table_name
where column_name=sysdate-2

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does a join table need a primary key?

533


Is sql free?

501


Can instead of triggers be used to fire once for each statement on a view?

537


How to know the last executed procedure?

589


Compare sql & pl/sql

609






what is recursive stored procedure? : Sql dba

529


What does := mean in pl sql?

555


Are pl sql variables case sensitive?

596


How many clustered indexes can you have?

534


How would you reference column values before and after you have inserted and deleted triggers?

622


What is the life of an sql statement?

525


What is the difference between left join and right join?

502


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

556


What is pl/sql table? Why is it used?

561


What is the difference between a primary key and a clustered index?

525