Interested to Buy Any Domain ? << Click Here >> for more details...
Display the order number and the number of months since the
order was shipped for all orders that have been shipped in
the last year (365 days). (Hint: Unshipped orders will have
a null value).
- 1 Answers
- 4035 Views
- I also Faced
- E-Mail Answers
Answer / ankit
Select Order_num, MONTHS_BETWEEN(SYSDATE,Shipped_date) no_of_months from Table where shipped_date is not null and to_date('sysdate','YYYY') = '2012';
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
In Oracle 9i what does "i" Stands for?
How would you design a database for an e-commerce website?
sql query to get zero records from a table
What is rowid and rownum in oracle?
Can a formula column referred to columns in higher group ?
What privilege is needed for a user to create tables in oracle?
What exactly do quotation marks around the table name do?
What is ADDM Advisor in Oracle?
how to retrieve data from different tables ,place this data in different excel worksheets.
ABOUT IDENTITY?
What are the uses of Database Trigger ?
Oracle General 
