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.
Answers were Sorted based on User's Feedback
Answer / monalisa dalbehera
select max(Order_Date) from Order_Name ;
Is This Answer Correct ? | 13 Yes | 3 No |
Answer / pritesh
select * from order_name where order_date=(select max
(order_date) from order_name)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gurudath mallya
select * from Order_Name where Order_Date=max(Order_Date);
Is This Answer Correct ? | 8 Yes | 9 No |
Answer / pardeeprajan
kindly give a delete option for the users to delete wrong
answer. administrator also should verify the answers regularly
Is This Answer Correct ? | 2 Yes | 4 No |
Answer / akki julak
SELECT ORDER_DATE FROM ORDER_NAME
WHERE ROWID=(SELECT MAX(ROWID) FROM ORDER_NAME);
Is This Answer Correct ? | 2 Yes | 5 No |
How do I debug a stored procedure?
How many tables can a sql database have?
There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
What are the properties of a transaction?
What are secondary keys?
Which is better varchar or nvarchar?
What is Collation Sensitivity ? What are the various type ?
How do you create a unique index?
I want to know the difference between A Record Type and a Table.
What are string functions in sql?
How to add new employee details in an employee_details table with the following details
What is difference between joins and union?