wa procedure to return the month and the no'f developers
joined in each month.
Answers were Sorted based on User's Feedback
Answer / kiran
select count(*) "NoFDevelopers",to_char(hiredate,'Mon') from emp group by to_char(hiredate,'Mon');
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / vishal narkhede
select to_char(hiredate, 'MON-RRRR'),count(1) from emp
group by to_char(hiredate, 'MON-RRRR')
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / narenkumar reddy
create or replace procedure
procdure_name
cursor c1 is select count(*),month from table
is
begin
for i in c1
loop
dbms_output.put_line(i.count(*)||i.month)
end loop;
end;
| Is This Answer Correct ? | 2 Yes | 6 No |
what are the difference between clustered and a non-clustered index? : Sql dba
What is microsoft t sql?
can we call a procedure from a function?
what is the difference between a local and a global temporary table? : Sql dba
Is trigger a stored procedure?
What is asqueryable?
How to change sql*plus system settings?
Is record in pl sql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
Can u create a primary key with out unique index.
What is a dynamic query?
what is ref cursor in pl/sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)