Interested to Buy Any Domain ? << Click Here >> for more details...
Table Student has 3 columns,Student_id,Student_Name &
Course_Id. Table Course has 2 columns, Course_Id &
Course_Name.Write a query to listdown all the Courses and
number of student in each course.
- 10 Answers
- 20586 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 48 Yes | 3 No |
Post New Answer View All Answers
How can you fetch common records from two tables?
Is sql sequential or random?
Why do we create views in sql?
Why is sql*loader direct path so fast?
what is an alias command? : Sql dba
Explain what is a database?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is sql and explain its components?
In what condition is it good to disable a trigger?
What is sql*plus?
Why we use triggers in mysql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is java sql driver?
What is the difference between row level and statement level trigger?
Why do we need databases?
