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
- 8166 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / pritesh
select * from order_name where order_date=(select max
(order_date) from order_name)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you inner join the same table?
Why do we need pl sql?
What is orm in sql?
Why use subqueries instead of joins?
what is a cursor? : Sql dba
What does count (*) mean?
How to know the last executed procedure?
What is a data definition language?
What is the difference between left and left outer join?
Which table is left in join?
what is single byte over head in oracle..?
What is the difference between view and stored procedure?
What type of database is cloud sql?
Why do we use function in pl sql?
What are the different types of joins in sql?
