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



Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

Answer / monalisa dalbehera

select max(Order_Date) from Order_Name ;

Is This Answer Correct ?    13 Yes 3 No

Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

Answer / pritesh

select * from order_name where order_date=(select max
(order_date) from order_name)

Is This Answer Correct ?    2 Yes 0 No

Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

Answer / gurudath mallya

select * from Order_Name where Order_Date=max(Order_Date);

Is This Answer Correct ?    8 Yes 9 No

Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

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

Table Order_Name has a column Order_Date which gives the date & Time at which the order is pas..

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

Post New Answer

More SQL PLSQL Interview Questions

How do I debug a stored procedure?

0 Answers  


How many tables can a sql database have?

0 Answers  


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.

2 Answers   Maruti Suzuki,


What are the properties of a transaction?

0 Answers  


What are secondary keys?

0 Answers  






Which is better varchar or nvarchar?

0 Answers  


What is Collation Sensitivity ? What are the various type ?

0 Answers  


How do you create a unique index?

0 Answers  


I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,


What are string functions in sql?

0 Answers  


How to add new employee details in an employee_details table with the following details

0 Answers  


What is difference between joins and union?

0 Answers  


Categories