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 difference between execution of triggers and stored procedures?

1097


What are the basic techniques of indexing?

1047


what is the syntax used for partition in tsql? : Transact sql

996


Does execute immediate commit?

1192


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

935


What is sqlservr exe?

963


Difference between global and parameter variables?

1947


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2147


Where can I learn sql for free?

977


What is group function in sql?

1000


How to avoid using cursors?

1096


How many sql core licenses do I need?

927


What does the base_object_type column shows in the user.triggers data dictionary view?

1027


Should I use mbr or gpt?

1009


How would you convert date into julian date format?

988