Qtr No. 213, New Town Yehlanka Indore 454775
Consider the table schema.
Student (Student_id,student_name ,dept_id)
Department(dept_id,dept_name)
Which of the following query would display names of the students who are studying in same department as mike?
Select s1.student_name from student s1 inner join student s2 on s1.dept_id=s2.dept_id and s1.student_name='mike' where s1.student_name<>'mike';
Select s1.student_name from student s1 inner join student s2 on s1.dept_id=s2.dept_id and s2.student_name='mike' where s1.student_name<>'mike';
To get all Infosys Certified PostgreSQL Associate Exam questions Join Group https://bit.ly/infy_premium_group
We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.
Qtr No. 213, New Town Yehlanka Indore 454775
admin@prepflix.in
