SQL combining or,and query

Question

I have one table called student.I want to select a student name who is living in chennai or madurai and born on december 8 1996.The table column name is (name,city,DOB). Sort the result by name. I have written like this and i got error "Invalid relational operator".

SELECT name
FROM student
WHERE city='chennai' OR 'madurai' AND DOB='december 8 1996'
ORDER BY name;

You have incorrect syntax. This will work: WHERE (city='chennai' OR city = 'madurai') AND DOB='december 8 1996' — Stuart
– Stuart, Commented Jul 4, 2019 at 15:12
or use where city IN ('chennai','madurai') AND DOB='december 8 1996'. — mighty_dev
– mighty_dev, Commented Jul 4, 2019 at 15:32

RiggsFolly · Accepted Answer · 2019-07-04 15:20:21Z

2

You have to mention the column in each where clause test.

Also if you are mixing AND and OR you need to apply some parenthasis to ensure they are applied correctly.

Also the date should be in yyyy-mm-dd format Assuming that you have deined DOB as a DATE type. And you should have if it is holding a date.

SELECT name
FROM student
WHERE (city='chennai' OR city='madurai' ) AND DOB='1996-12-08'
ORDER BY name;

edited Jul 4, 2019 at 15:20

answered Jul 4, 2019 at 15:13

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL combining or,and query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related