Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
Question 493 |
Consider the query : SELECT student_name FROM student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEM1_MARK5SEM2_MARK);
Which of the following is true ?
Which of the following is true ?
It gives the name of the student whose marks in semester 1 and semester 2 are same. | |
It gives all the names and roll nos of those students whose marks in semester 1 and semester 2 are same. | |
It gives the names of all the students whose marks in semester 1 and semester 2 are same. | |
It gives roll numbers of all students whose marks in semester 1 and semester 2 are same. |
Question 493 Explanation:
Since both the queries are not related so you can solve inner query first and then can solve outer query.
Correct Answer: C
Question 493 Explanation:
Since both the queries are not related so you can solve inner query first and then can solve outer query.
Subscribe
Login
0 Comments