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
How do I count rows in sql query?
How much does sql certification cost?
what are the features and advantages of object-oriented programming? : Sql dba
Can we join same table in sql?
How do I find duplicates in sql?
What is scope and visibility in PL/SQL?
Is primary key always clustered index?
What is the use of non clustered index?
What is relationship? How many types of relationship are there?
Why is a primary key important?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What does subquery mean in sql?
What is a mutating table and a constraining table?
Can we use join in subquery?
What is the unique index?