Interested to Buy Any Domain ? << Click Here >> for more details...
using subquery how can i calculate working days in a month?
- 3 Answers
- 13163 Views
- Spice Telecom, I also Faced
- E-Mail Answers
Answer Posted / mayru
SELECT COUNT( *)
FROM
(SELECT ROWNUM RNUM
FROM ALL_OBJECTS
WHERE ROWNUM <= TO_DATE('01-OCT-2011') - TO_DATE('01-SEP-2011') + 1
)
WHERE TO_CHAR(TO_DATE('01-SEP-2011') + RNUM - 1, 'DY') NOT IN('SAT', 'SUN');
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between sql and isql*plus?
How do you bind variables in pl sql?
Can we have two clustered index on a table?
Why do we use triggers?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is trigger and types?
Can we insert in view in sql?
Can we use loop in sql?
what is sql profiler? : Sql dba
Does view contain data?
How to get each name only once from an employee table?
Is not null in sql?
What is localdb mssqllocaldb?
Define select, insert, create, delete, update, drop keywords
Explain constraints in sql?
