Answer Posted / p.rajasekar

ex
1)Method
Table tab1 data like Followings

Month date1 Working
Jan 1 0
Jan 1 1
Jan 1 1
Jan 1 0
.
.
.

Then the query should be

select Month,count(Working) from monthname m where working=1
group by Month,working

You will get answer 2;
2 Method

If we store the working days in same column

eg like(1=>Denotes Working,0=>denotes off)
Month Day1
Jan 101010101111



select Month,length(trim(replace(b.Day1,'0','')))
NoofWorkDays from workdays b


Please test it.Let me know the feed back

What is vector point function?

1005

---

What are inbuilt functions in sql?

992

---

What is synonyms?

999

---

what are all the different normalizations? : Sql dba

962

---

Why self join is used in sql?

919

---

Why we use joins in sql?

926

---

what happens if null values are involved in expressions? : Sql dba

1001

---

Does mysql support pl sql?

1099

---

What is %s in sql?

972

---

Explain isolation levels. : Transact sql

1017

---

How do you know if a relationship is 2nf?

877

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2230

---

what is the syntax for using sql_variant_property? : Transact sql

990

---

Show how functions and procedures are called in a pl/sql block.

1042

---

Does sql*plus also have a pl/sql engine?

1039

---