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
- 20666 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chinnu
SELECT *(Courses,students) FROM Table Student
| Is This Answer Correct ? | 3 Yes | 14 No |
Post New Answer View All Answers
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
how to create a new view in mysql? : Sql dba
How to fetch alternate records from a table?
what is a composite primary key ? : Sql dba
what is the difference between sql and t-sql? : Transact sql
What are the built in functions of sql?
What are the different set operators available in sql?
What is an escape character in sql?
What is structural independence and why is it important?
Why we use sql profiler?
What is your daily office routine?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is tuple in sql?
what is acid property in database? : Sql dba
