Home » SQL & PL/SQL » SQL & PL/SQL » Query problem.
Query problem. [message #291346] Thu, 03 January 2008 23:38 Go to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

i have leave schedule table of employees.

employee name from date to date
martin 1-sep-07 14-sep-07
julia 29-sep-07 2-dec-07

now i want to get number of leaves each employee taken in
month of September.
also julia days in September no of December.

[Updated on: Thu, 03 January 2008 23:41]

Report message to a moderator

Re: Query problem. [message #291351 is a reply to message #291346] Thu, 03 January 2008 23:47 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

This seems to be a homework!

Please format your question...

Naveen
Re: Query problem. [message #291354 is a reply to message #291351] Thu, 03 January 2008 23:52 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

well ..sorry..
it was bit confusion out there..
i have solved.
thanks.
Re: Query problem. [message #291356 is a reply to message #291346] Thu, 03 January 2008 23:57 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Please post your solution for those who come after you.
Re: Query problem. [message #291374 is a reply to message #291354] Fri, 04 January 2008 00:58 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also before posting the answer or another question, please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Does anyone have a query for the Journal Entry Reserve Ledger Report?
Next Topic: Changing tablespace (2 merged)
Goto Forum:
  


Current Time: Wed Dec 07 04:59:13 CST 2016

Total time taken to generate the page: 0.10092 seconds