in table there r so many rows write a query which two rows r
updated last two day befor?
Answers were Sorted based on User's Feedback
Answer / srinivas
select * from <table name>
where rownum<=2
order by last_updated_date
Is This Answer Correct ? | 29 Yes | 6 No |
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 |
Answer / narenkumar reddy
select column_name from table_name
where column_name=sysdate-2
Is This Answer Correct ? | 1 Yes | 2 No |
how many values can the set function of mysql take? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
What are the usage of SAVEPOINTS?
SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows
Can triggers stop a dml statement from executing on a table?
What is an emotional trigger?
What is sql used for?
what is cursor procedure
what is global variable in pl/sql
What is the difference between the Primary and Foreign key?
What are all the common sql functions?
Does inner join remove duplicates?