select max(Order_Date) from 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 / monalisa dalbehera

5 Answers
9312 Views
Thomson, I also Faced
E-Mail Answers

Answer Posted / monalisa dalbehera

select max(Order_Date) from Order_Name ;

Is This Answer Correct ?

13 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does google use sql?

1005

Is left join inner or outer by default?

1072

What is delimiter in pl sql?

1098

What are the different sql languages?

1091

How do you remove duplicates without using distinct in sql?

1017

What problem one might face while writing log information to a data-base table in pl/sql?

1247

What is character functions?

1114

What is a memo field?

1015

What are the constraints available in sql?

1085

What is the most restrictive isolation level? : Transact sql

1124

How do I start sql profiler?

1046

What are aggregate and scalar functions?

1085

What are the rules to be applied to nulls whilst doing comparisons?

1367

how to get help information from the server? : Sql dba

989

What is ttitle and btitle?

1113