The Queries in this page solved at the library database. It is a sample database generated by randomly records. You can download it from the link. You will see more than 500 examples in the future. You can filter from the search panel above by selecting sql statements. I hope you will like it

SQL Brackets Examples

1-) List the students whose name is "Jane" or "Kane" and school number less than 30

Solution 1) 

select *from students 
     where (name='Kane' or name= 'Jane') and studentId <30

Solution 2) 

Select * from students 
     where name='Kane' and studentId <30 or name='Jane' and studentId <30

Solution 3) 

select * from students 
     where name in('Kane','Jane') and studentId<30

ETİKETLER

Select - Where - Brackets - Multi Condition -
2-) List the students whose name Edwards or Baker and student number less than 30

Solution 1) 

select * from students 
	where ("Edwards" or "Baker") and studentId<30

Solution 2) 

select * from students 
	where name='Edwards' and studentId<30 or 
	      name='Baker' and studentId<30

ETİKETLER

Select - Where - Brackets - Multi Condition -
Library Database
Database