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
- 8167 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
What are literals in sql server?
What are pl/sql packages?
what is the stuff function and how does it differ from the replace function? : Sql dba
Does sql backup shrink transaction log?
Is sql easier than java?
Show the two pl/sql cursor exceptions.
What are sql data types?
What is a table?
what is a tablespace? : Sql dba
What company owns postgresql?
What are different methods to trace the pl/sql code?
How to connect a sql*plus session to an oracle server?
How to run pl/sql statements in sql*plus?
What are the two different parts of the pl/sql packages?
How to check if a column is nullable before setting to nullable?
