Home > IT Answers > Oracle > Grouping of a/c.
235235235
95 pts.
 Grouping of a/c.
Oracle, SQL Worksheet
I am using Oracle and through SQL Worksheet i want to get information as followes.  My table Name is bilmst and field 1 enterdate and field 2 a/c. no  I want to group no of a/cs fininacial year wise. My financial year starts from 01-jul to 30-jun for example 2005-06 means from 01-jul-05 to 30- jun-06. I want to group a/cs based on enterdate for last ten financial year wise. i would like to obtained infromation through Select Command pl. see

Software/Hardware used:
software is used
ASKED: March 27, 2012  6:55 AM
UPDATED: April 6, 2012  2:15 PM
RELATED QUESTIONS
Answer Wiki:
235235235, you have asked this same question 3 times. If you continue doing this, your questions will probably be deleted. 3 queries that produce the results you want were provided here: <a href="http://itknowledgeexchange.techtarget.com/itanswers/sql-wks-select-command/">SQL WKS SELECT COMMAND</a> If you don't understand them, or want to provide any feedback, <b>please </b>continue the discussion there.
Last Wiki Answer Submitted:  March 28, 2012  5:26 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

thanks my problem has solved

235235235
 95 pts.
 

Thanks for confirming.

Can you share your solution ?

Thanks,

carlosdl
 63,580 pts.