Which of the following query is correct for using comparison operators in SQL?

Question

TuteeHUB · Accepted Answer

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

TuteeHUB · Answer

SELECT name, course_name FROM student WHERE age>50 and

TuteeHUB · Answer

SELECT name, course_name FROM student WHERE age>50 and age

TuteeHUB · Answer

SELECT name, course_name FROM student WHERE age>50 and WHERE age

TuteeHUB · Answer

None of these

1.	Which of the following query is correct for using comparison operators in SQL?
A.	SELECT name, course_name FROM student WHERE age>50 and <80;
B.	SELECT name, course_name FROM student WHERE age>50 and age <80;
C.	SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
D.	None of these
Answer» C. SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

Discussion