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
- 9315 Views
- Thomson, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / monalisa dalbehera
select max(Order_Date) from Order_Name ;
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / pritesh
select * from order_name where order_date=(select max
(order_date) from order_name)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gurudath mallya
select * from Order_Name where Order_Date=max(Order_Date);
| Is This Answer Correct ? | 8 Yes | 9 No |
Answer / pardeeprajan
kindly give a delete option for the users to delete wrong
answer. administrator also should verify the answers regularly
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / akki julak
SELECT ORDER_DATE FROM ORDER_NAME
WHERE ROWID=(SELECT MAX(ROWID) FROM ORDER_NAME);
| Is This Answer Correct ? | 2 Yes | 5 No |
What are three advantages to using sql?
What is the difference between cross join and natural join?
What do we need to check in database testing?
What is data definition language?
What view means?
What is a variable in sql?
What is execute immediate?
What are the advantages of normalization?
What is query syntax?
give the syntax of grant and revoke commands? : Sql dba
What is the size of partition table?
How many clustered indexes can you have?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
