Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 does sign mean sql?

1122


How can I speed up sql query?

968


Is left join same as join?

1002


how do you login to mysql using unix shell? : Sql dba

1086


What are the three pl sql block types?

1016


How can I get the number of records affected by a stored procedure?

1069


How much does sql certification cost?

1096


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1141


How we can update the view?

1054


How to start oracle sql developer?

1049


What is the difference between view and stored procedure?

964


Explain cursor types?

1034


Can %notfound return null after a fetch?

1068


What is a recursive stored procedure?

1190


What mean sql?

1022