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.
- 5 Answers
- 9148 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / pritesh
select * from order_name where order_date=(select max
(order_date) from order_name)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the types of queries in sql?
What is a composite primary key?
Can we enter data in a table in design view?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Does sap use sql?
Is sql microsoft?
What are stuff and replace function?
Is sqlexception checked or unchecked?
what are date and time data types? : Sql dba
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
List the various privileges that a user can grant to another user?
What is an escape character in sql?
How many types of primary keys are there?
How to add a column ‘salary’ to a table employee_details?
What is sql comments?
