Interested to Buy Any Domain ? << Click Here >> for more details...
using subquery how can i calculate working days in a month?
- 3 Answers
- 13124 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 are views in sql?
What is a design view?
What is sql entity?
What is group function in sql?
What is the least restrictive isolation level? : Transact sql
What is the difference between truncate and drop statements?
Define concurrency control. : Transact sql
Explain the significance of the & and && operators in pl sql.
how would concatenate strings in mysql? : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What are tables in sql?
Does db2 use sql?
What is sql and also describe types of sql statements?
How do you write an inner join query?
How do you declare a variable in pl sql?
