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
- 9311 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 is cursor explain with example?
Is left join inner or outer?
How does cross join work in sql?
What is dynamic SQl and how you will create and execute dynamic sql?
How do you use collections in procedure to return the resultset?
define sql insert statement ? : Sql dba
what is a composite primary key ? : Sql dba
What are the two types of exceptions in pl/sql?
How to run sql functions in pl/sql?
What is the difference between left and left outer join?
How to return an array from java to pl/sql?
What are the string functions in sql?
-
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)
