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
9085 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 is minus?

971

How can we implement rollback or commit statement in a trigger?

1016

What are functions in sql?

936

What is cursor and why it is required?

1163

What is a unique key and primary key and foreign key?

954

What is left join in postgresql?

1028

How to set up sql*plus output format in oracle?

1013

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2150

What is the use of stored procedures?

1021

What are the different types of triggers?

1112

Can we use insert statement in function?

980

Do stored procedures prevent sql injection?

953

Differentiate between pl/sql and sql?

1129

Is pl sql different from sql?

967

Why do we use joins in sql?

956