in table there r so many rows write a query which two rows r
updated last two day befor?
Answer Posted / 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 |
Post New Answer View All Answers
What is group function in sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Why we use joins in sql?
what is the use of double ampersand (&&) in sql queries?
What is the non-clustered index in sql?
Explain scalar functions in sql?
What are the advantages of sql? Explain
Which sorts rows in sql?
What is autocommit sql?
What is the sql case statement?
What type of join is sql join?
What are tables and fields?
what is a composite key ? : Sql dba
What is a primary key? Explain
explain advantages of innodb over myisam. : Sql dba