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

Why do we need databases?

1085

---

what is 'mysqladmin' in mysql? : Sql dba

1073

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2598

---

what are the different type of sql's statements ? : Sql dba

975

---

What is the starting oracle error number? What is meant by forward declaration in functions?

1040

---

what are the limitations of identity column? : Transact sql

1159

---

Which table is left in join?

1016

---

what are all the different types of indexes? : Sql dba

1103

---

What is rownum in sql?

1091

---

Can we have two clustered index on a table?

1077

---

what are set operators in sql? : Sql dba

1105

---

Is coalesce faster than isnull?

1012

---

What is the difference between an inner and outer join?

1055

---

What is mdf ldf and ndf?

1056

---

Explain the purpose of %type and %rowtype data types with the example?

1044

---