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
9175 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 time based sql injection?

965

How can we link a sql database to an existing android app?

1038

How do I truncate a word?

1100

Why we use pl sql?

968

What is a full join sql?

1064

Can unique keys be null?

918

How to combine two stored procedures in sql?

1245

what are the different index configurations a table can have? : Sql dba

1003

Can we debug stored procedure?

1032

how mysql optimizes distinct? : Sql dba

1086

How is pl sql different from sql?

1099

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1019

what is “go” in t-sql? : Transact sql

1117

What is difference between pl and sql?

1071

Is sql a programming?

982