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 / pritesh

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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is update query?

540


What is the max nvarchar size?

510


how many ways to get the current time? : Sql dba

520


What are the three forms of normalization?

520


What is join view in sql?

504






What is a clob in sql?

558


What is difference between my sql and sql?

524


What is execution plan in sql?

542


Define commit?

537


What is pl sql record in oracle?

555


How is data stored in sql?

545


explain the options of myisamchk to improve the performance of a table. : Sql dba

538


how to shut down the server with 'mysqladmin'? : Sql dba

537


How to Execute a Package in PL/SQL.?

573


What is difference between sql and excel?

508