I need to get the values of the previous quarter.how to do
this?eg: if my cuurent month is may i need to get the datas
of the month jan,feb,march.Can it be done in oracle.I tried
with date function q but for the month jan its not
retriving the previous quarter(oct-dec).how to solve
this.plpz anyone help me?
- 2 Answers
- 6782 Views
- Philips, I also Faced
- E-Mail Answers
Answer Posted / jas
yes its possible...u can use the date functions
select * from table_name where col_name
between add_months (trunc(sysdate,'MONTH')-3)
and trunc(sysdate,'MONTH')-1
try usgin this might help..
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the difference between post-database commit and post-form commit?
types of indexes and the rationale behind choosing a particular index for a situation.
In which language oracle has been developed?
What is an Oracle index?
What is rowid and rownum in oracle?
Is postgres faster than oracle?
How to execute a stored program unit?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
what is insert all statement in sql
How can I get column names from a table in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
what's query optimization and without use of IN AND Exist can we get another way data from query
Give the advantages and disadvantages of clusters.
How to create an oracle database manually?
Where are the settings stored for each instance in oracle?
