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.
- 5 Answers
- 7405 Views
- Thomson, I also Faced
- E-Mail Answers
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 can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What packages(if any) has oracle provided for use by developers?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What are the usages of sql?
What is cursor in pl sql?
What is a nested table in word?
Why functions are used in sql?
how to use regular expression in pattern match conditions? : Sql dba
Is there any restriction on the use of union in embedded sql?
Explain what is table in a database?
What is forward declaration in pl sql?
Which query operators in sql is used for pattern matching?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
How do I save a sql query?
How do I run a sql trace?
