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

How do you optimize a query?

524


Which is faster union or join?

480


What is the difference between an inner and outer join?

524


How do you create a db file?

510


Explain exception handling in pl/sql?

520






name 3 ways to get an accurate count of the number of records in a table? : Sql dba

550


Is pl sql better than sql?

540


What are the types of variables use in pl sql?

490


What is the basic form of sql query?

480


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

521


How can I make sql query run faster?

546


What is the best free sql database?

552


What are user defined functions?

568


Can we insert data into view?

512


What is sqlite used for?

514