select command

95 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

<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!

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    70,220 pointsBadges:
    report
  • 235235235
    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
    95 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following