Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query
Answers were Sorted based on User's Feedback
Answer / soorai ganesh
Hi dude, If u use SQLSERVER 2005 this will help u.......
-------------------------------------------------------
Create table student (studName varchar(50), doj smalldatetime)
insert into student values('Ganesh','05/26/2008')
insert into student values('Ramesh','03/26/2008')
insert into student values('Dinesh','03/26/2008')
insert into student values('Suresh','04/26/2008')
Select * from student
SELECT 'Students Admission by Monthwise',[3] AS March,[4] AS April,[5] AS May
FROM(
SELECT studName,
Month(doj) monthname
FROM student
) A
PIVOT
(
COUNT(studname)
FOR monthname in
([3],[4],[5])
) AS PVT
Is This Answer Correct ? | 12 Yes | 1 No |
SELECT Sum([1]) AS Jan, Sum([2]) AS Feb, Sum([3]) AS Mar,Sum([4]) as Apr,Sum([5]) as May,Sum([6]) as Jun,
Sum([7]) as Jul,Sum([8]) as Aug,Sum([9]) as Sep,Sum([10]) as Oct,Sum([11]) as Nov,Sum([12]) as Dec
FROM (SELECT Month(JoinDate) as Mon
FROM AAA) ps
PIVOT
(Count(Mon) FOR Mon IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) AS pvt
group by [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12]
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pradip jain
select datename(mm,doj), count(studname) from student group
by doj
Is This Answer Correct ? | 2 Yes | 0 No |
What are the types of user defined functions in sql server?
What is nolock?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is the downside of using udf?
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
Explain boyce and codd normal form(bcnf)?
what is normalization? what is denormalization?
What happens when transaction log is full?
What are cursors in ms sql server?
What is the template in sql?
What is rank function?
How do we know if any query is retrieving a large amount of data or very little data?