select * from order_name where order_date=(select max (order

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.

Question Posted / pritesh

5 Answers
8913 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

Please Help Members By Posting Answers For Below Questions

What do you understand by exception handling in pl/sql?

961

What are the advantages of normalization?

1034

What's the procedure?

862

What is the purpose of my sql?

896

What is a dynamic query?

968

Explain the commit statement.

1101

what is 'mysqladmin' in mysql? : Sql dba

971

is it possible to pass an object or table to a procedure as an argument?

1057

what is msql? : Sql dba

939

What is a constraint? Tell me about its various levels.

1081

How to change sql*plus system settings?

992

what are the types of subquery? : Sql dba

1046

Do ddl statements need commit?

919

How do you write a complex sql query?

1006

Explain what is a view?

994