ExamCompetition Your Success, Our Mission
Login Register
Question discussion

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

312187Medium 1 reply 2,333 views
33
Which of the following query is correct for using comparison operators in SQL?
  • ASELECT name, course_name FROM student WHERE age>50 and <80;
  • BSELECT name, course_name FROM student WHERE age>50 and age <80;
  • CSELECT name, course_name FROM student WHERE age>50 and WHERE age<80;
  • DNone of these
Correct answer: B
Join the discussion Report an error

Discussion 1

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