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
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
describe transaction-safe table types in mysql : sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What are stored procedures used for?
Can we alter stored procedure?
how to get a list of columns in an existing table? : Sql dba
Why do we use view in sql?
I need a function for a train ticket reservation please answer it thanks in advance
What is a join query?
What are the advantages of pl sql?
what is cursor. write example of it. What are the attributes of cursor.
What is pl sql in dbms?
What is t-sql? : Transact sql
What is a constraint? Tell me about its various levels.
what is view? : Sql dba