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
9316 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 the maximum number of columns in sql table?

1231

Why we use stored procedure instead of query?

1048

Can we call dml statement in function?

1099

What is the difference between in and between in sql?

1109

Explain the uses of database trigger.

1179

What are types of exception?

963

Is merge a dml statement?

1032

Which software is used for pl sql programming?

1034

What is the difference between view and stored procedure?

1003

How do I write a cron which will run a sql query and mail the results to agroup?

1035

What are the most important ddl statements in sql?

1190

Which certification is best for sql?

1042

What is triggering circuit?

1108

how can we know the count/number of elements of an array? : Sql dba

1109

Is trigger a stored procedure?

984