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 / gurudath mallya
select * from Order_Name where Order_Date=max(Order_Date);
Is This Answer Correct ? | 8 Yes | 9 No |
Post New Answer View All Answers
What is pragma in sql?
What are the different schemas objects that can be created using pl/sql?
What are the uses of sysdate and user keywords?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What are the two characteristics of a primary key?
what is transaction? : Sql dba
What programs use sql?
What is the difference between syntax error and runtime error?
Is primary key a clustered index?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is scope and visibility in PL/SQL?
Is sql a backend?
What is schema in sql?
What is bind reference and how can it be created?
How do you explain an index number?