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
What is the difference between execution of triggers and stored procedures?
What are the basic techniques of indexing?
what is the syntax used for partition in tsql? : Transact sql
Does execute immediate commit?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is sqlservr exe?
Difference between global and parameter variables?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
Where can I learn sql for free?
What is group function in sql?
How to avoid using cursors?
How many sql core licenses do I need?
What does the base_object_type column shows in the user.triggers data dictionary view?
Should I use mbr or gpt?
How would you convert date into julian date format?