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
9083 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

How do I create an index in word?

1009

Is join an inner join?

943

what is denormalization. : Sql dba

1087

Explain some predefined exceptions.

1018

How to start oracle sql developer?

1011

How many types of functions are there in sql?

929

What is the difference between explicit and implicit cursors in oracle?

1045

What is index example?

991

Does group by remove duplicates?

1019

How to display the records between two range in Oracle SQL Plus?

1131

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4245

What is sql catalog?

999

How can we store rows in PL/SQL using array?

1202

What normalization means?

948

What are the different tcl commands in sql?

1151