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.
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
What is the use of non clustered index?
Can a primary key be a foreign key?
What is percent sign in sql?
What are its different types of dbms?
Why do we need pl sql?
What is rank dense_rank and partition in sql?
what tools available for managing mysql server? : Sql dba
how to present a past time in hours, minutes and seconds? : Sql dba
What are the commands used in sql?
Give the order of sql select?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is a boolean in sql?
What is snowflake sql?
Can we use pl sql in mysql?
Is sql database free?