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
9090 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 partition by in sql?

1048

what is innodb? : Sql dba

1084

What are the two types of periodical indexes?

925

What is a temporal table?

915

What can I use instead of union in sql?

948

What are the types of subqueries?

1047

what is the difference between where clause and having clause? : Sql dba

985

what does the t-sql command ident_incr does? : Transact sql

1054

How do I view a sql database?

1006

Why do we need cursor in pl sql?

1121

describe mysql connection using mysql binary. : Sql dba

1047

What is a design view?

915

In what condition is it good to disable a trigger?

995

What is the reports view in oracle sql developer?

957

what is a tablespace? : Sql dba

1037