Answer / monalisa.dalbehera

select count(s.student_id),c.cource_name
from student s,course c
where c.course_id=s.course_id
group by c.course_name;

Answer / pradip d

select count(student_name),course_name from student,course
where course.course_id=student.course_id group by course_name;

Answer / kalyan

SELECT COURSE_NAME,COUNT(B.STUDENT_ID) NO_OF_STUDENTS
FROM COURSE A LEFT OUTER JOIN STUDENT B
USING (COURSE_ID)
GROUP BY A.COURSE_NAME

OR

SELECT COURSE_NAME,COUNT(B.STUDENT_ID) NO_OF_STUDENTS
FROM COURSE A , STUDENT B
WHERE A.COURSE_ID = B.COURSE_ID(+)
GROUP BY A.COURSE_NAME

This will list all the courses with no of students

Answer / neo28

select Course_Id, Course_Name, count(Student_id) from
(
select c.Course_Id, c.Course_Name, s.Student_id
from Student s, Course c
where s.Course_Id(+) = c.Course_Id
) group by Course_Id
order by Course_Id;

Answer / iamanocp

select c.course_id, count(s.student_id)
from student s, course c
where s.course_id = c.course_id
group by c.course_id;

Answer / lova raju allumalla

select count(stud_name),course_name from student s,course c
where s.course_id = c.course_id group by course_name
/

Answer / cm

select s.stud_name,c.course_name from student s,course c
where s.course_id = c.course_id group by
s.stud_name,c.course_name;

Answer / dinakar

select course_id,count(*) from student where course_id in
(select course_id From course)
GROUP BY COURSE_ID

Answer / guest

select count(student_id),course_name ,student_name
from student s, course c
where s.course_id = c.course_id
group by course_id
order by student_id desc

Answer / chinnu

SELECT *(Courses,students) FROM Table Student

Explain isolation levels. : Transact sql

0 Answers  

Does sap use sql?

0 Answers  

How many triggers can be applied to a table?

0 Answers  

real time applications of nullif?

3 Answers  

Difference between global and parameter variables?

0 Answers   TCS,

what is user defined functions? : Sql dba

0 Answers  

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

What is $$ in sql?

0 Answers  

what is the syntax for using sql_variant_property? : Transact sql

0 Answers  

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

How to read xml file in oracle pl sql?

0 Answers