It's simple No need to use Cursor for that select Month(Joindate)

wa procedure to return the month and the no'f developers
joined in each month.

Question Posted / arrry.net

Answer Posted / arrry.net

It's simple
No need to use Cursor for that

select Month(Joindate)as MONTH,count(*) as empCount from dbo.tblEmployee
Group by Month(Joindate)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a natural join?

992

What is the meaning of disabling a trigger?

1115

What are commit, rollback, and savepoint?

940

Why should I use postgresql?

973

What are the types of records?

953

Which join is default?

898

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1066

What is use of package in pl sql?

953

Can triggers stop a dml statement from executing on a table?

1027

What language is oracle sql developer?

941

What is the clause we need to add in function body to return variable?

968

What do you mean by stored procedures? How do we use it?

931

What is the difference between subquery and correlated query?

991

How can we avoid duplicating records in a query?

925

Can we write ddl statements in functions?

1054