select * from Order_Name where Order_Date=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 / gurudath mallya

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

Please Help Members By Posting Answers For Below Questions

What is difference between sql function and stored procedure?

1063

What does data normalization mean?

1028

What is cross join example?

1068

How do you optimize a stored procedure in sql?

1019

what is oracle database ? : Sql dba

1082

What are the advantages of pl sql?

1171

What is a full join sql?

1105

How delete all data from table in sql?

1079

What is sql rowcount?

1073

What is the most restrictive isolation level? : Transact sql

1128

Does sql require a server?

1057

What is the advantage of nosql?

1117

Can we insert delete data in view?

1004

Is not equal in sql?

1064

When can we use the where clause and the having clause?

1087