Interested to Buy Any Domain ? << Click Here >> for more details...
wa procedure to return the month and the no'f developers
joined in each month.
- 4 Answers
- 10182 Views
- Fidelity, I also Faced
- E-Mail Answers
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 |
Explain the difference between sql and mysql.
What are the differences between in and exists clause?
What is record data type?
How do I tune a sql query?
explain commit and rollback in mysql : sql dba
What is a CTE (Common Table Expression), and how is it different from a subquery?
What is difference between joins and union?
What are the most important characteristics of pl/sql?
How to avoid using cursors?
Are stored procedures faster than queries?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is the life of an sql statement?
-
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)
