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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of sqlerrd 3?

945


What are the commands used in sql?

1084


what are the properties and different types of sub-queries? : Sql dba

1036


how to include character strings in sql statements? : Sql dba

1077


how can we know the count/number of elements of an array? : Sql dba

1066


Can a trigger call a stored procedure?

1075


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

1086


What is a primary key sql?

1047


What is the source code of a program?

1075


What is pragma in sql?

1086


what is meant by urlencode and urldocode? : Sql dba

1180


how to calculate expressions with sql statements? : Sql dba

1040


What is bitemporal narrowing?

1314


Why we use join in sql?

979


What is a sql schema used for?

1110