Home > IT Answers > Oracle > select command
235235235
95 pts.
 select command
Oracle, Oracle commands, Oracle Table
i would like to collect informations from oracle date table through select query financial year wise my financial year starts from01 jul and ends on 30 jun. my task is to collect total number of entries from last ten financial years wise.

Software/Hardware used:
software
ASKED: March 21, 2012  7:49 AM
UPDATED: March 22, 2012  5:31 AM
RELATED QUESTIONS
Answer Wiki:
<i>Answer from CompleteITProfessional :</i> Depending on how your data is structured, you'll need a query similar to this: SELECT * FROM tablename WHERE datefield > SYSDATE - (365 * 10) If you're after more information on the financial years, you may need to convert the dates to financial years and go back 10 in the past. It's a generic query that I've provided but I hope it helps!
Last Wiki Answer Submitted:  March 21, 2012  9:27 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts. , CompleteITProfessional   340 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You need to provide more details if you really want to get useful answers.

You didn’t even tell us how you want to do this (using SQL ? or using some application ? something else ?)

Also, if you want to use SQL, you would have to provide some information about your database design.

carlosdl
 63,535 pts.
 

Thanks for your response.
Actually i am using Oracle 7.3.1 with Devloper 2000
I want to get information from a table name ‘bilmst’ having column name ‘a/c no.’ and
‘enterdate’ i want to collect information as follows
fy 01-07 No of A/Cs
to 30-06

2005-06 1500
2006-07 1000
2007-08 1200
2008-09 1100

i want to get information as example given above
my financial year from 01-07 to 30-06.
can i get information with select command as above format.
please guide.

Thank

Toqeer Akbar

235235235
 95 pts.