Table Order_Name has a column Order_Date which gives the
date & Time at which the order is passed.Find the table to
write a query to find out the latest order.
Answer Posted / gurudath mallya
select * from Order_Name where Order_Date=max(Order_Date);
| Is This Answer Correct ? | 8 Yes | 9 No |
Post New Answer View All Answers
How do you update a table in sql?
Why stored procedure is faster than query?
define sql insert statement ? : Sql dba
is mysql query is case sensitive? : Sql dba
How many databases can sql express handle?
Can we join same table in sql?
what is the difference between char_length and length? : Sql dba
Are sql connections encrypted?
What is java sql drivermanager?
What is data manipulation language?
When is a declare statement required?
what are the security recommendations while using mysql? : Sql dba
How can you load microsoft excel data into oracle? : aql loader
What is the difference between joins?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?