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

**Solution 1)**

```
Select * from students
where studentId<= 20 and studentId< 30
```

**Solution 2)**

```
Select * from students
where studentId between 20 and 30
```

ETİKETLER

Select - Where - Between - Multi Condition -
**Solution 1)**

```
select * from students
where name= 'James' and surname not like '%a%'
```

ETİKETLER

Select - Where - Like - Multi Condition -
**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 -
**Solution 1)**

```
select * from students
where name = 'Perez' and surname not like '%a%'
```

**Solution 2)**

```
select * from students
where name = 'Perez' and not surname like '%a%'
```

ETİKETLER

Select - Where - Multi Condition -
**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 -
**Solution 1)**

```
Select * from student
where name like 'a%' and studentId % 2 = 1
```

ETİKETLER

Select - Where - Multi Condition -
**Solution 1)**

```
Select top 1 * from students
where sinif= '10A' and gender= 'F'
order by newid()
```

ETİKETLER

Select - Top - Where - Order By - Multi Condition -
**Solution 1)**

```
Select students.name as studentName,students.surname,
books.name as BookName,takenDate
from students, borrows, books, types, authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
sinif='11B' and gender='F'
```

**Solution 2)**

```
Select students.name as studentName,students.surname,
books.name as BookName,takenDate
from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
where sinif='11B' and gender='F'
```

ETİKETLER

Select - Join - Where - Multi Condition - Çoklu Tablo -
**Solution 1)**

```
Select authors.name, authors.surname, books.name as bookName from authors
join books on authors.authorId = books.authorId
join types on types.typeId = books.typeId
where types.name = 'Drama'
```

**Solution 2)**

```
Select authors.name, authors.surname, books.name as bookName
from authors, books, types
where authors.authorId = books.authorId and
types.typeId = books.typeId and
types.name = 'Drama'
```

ETİKETLER

Select - Join - Where - Multi Condition - Çoklu Tablo -
**Solution 1)**

```
Select books.name as bookName, authors.name, authors.surname
from authors
join books on authors.authorId = books.authorId
where pagecount >300
```

**Solution 2)**

```
Select authors.name, authors.surname, books.name as bookName
from authors,books
where authors.authorId = books.authorId and pagecount >300
```

ETİKETLER

Select - Join - Where - Multi Condition - Çoklu Tablo -
**Solution 1)**

```
Select distinct students.* from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
join authors on authors.authorId = books.authorId
where authors.name = 'Isaac' and authors.surname = 'Asimov'
```

**Solution 2)**

```
Select distinct students.*
from students, borrows, books, authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
authors.authorId = books.authorId and
authors.name = 'Isaac' and authors.surname = 'Asimov'
```

ETİKETLER

Select - Join - Where - Multi Condition - Çoklu Tablo -
**Solution 1)**

```
Select distinct students.* from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
join authors on authors.authorId = books.authorId
where authors.name = 'Fyodor' and authors.surname = 'Dostoevsky' and sinif = '10A'
```

**Solution 2)**

```
Select distinct students.*
from students, borrows, books, authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
authors.authorId = books.authorId and
authors.name = 'Fyodor' and authors.surname = 'Dostoevsky' and
sinif = '10A'
```

ETİKETLER

Select - Join - Where - Multi Condition - Sub Query - Çoklu Tablo -
**Solution 1)**

```
Select sum(point) from books
join authors on authors.authorId = books.authorId
where authors.name = 'Emily' and authors.surname = 'Dickinson'
```

ETİKETLER

Select - Join - Where - Multi Condition - Aggragate - Çoklu Tablo -
**Solution 1)**

```
Select count(*) from books
join authors on authors.authorId = books.authorId
where authors.name = 'Edna' and authors.surname = 'Ferber'
```

ETİKETLER

Select - Join - Where - Multi Condition - Aggragate - Çoklu Tablo -
**Solution 1)**

```
Select count(*) from students
join borrows on students.studentId = borrows.studentId
where students.name = 'Alice' and students.surname = 'Wood'
```

ETİKETLER

Select - Join - Where - Multi Condition - Aggragate - Çoklu Tablo -
**Solution 1)**

```
Select sum(pageCount) from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
where students.name = 'Ainsley' and students.surname = 'Cooper'
```

ETİKETLER

Select - Join - Where - Multi Condition - Aggragate - Çoklu Tablo -
**Solution 1)**

```
Select count(distinct authorId) from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
where students.name = 'Ida' and students.surname = 'Gray'
```

ETİKETLER

Select - Distinct - Join - Where - Multi Condition - Aggragate - Çoklu Tablo -
**Solution 1)**

```
Delete from students
where name = 'Gray' and surname = 'King'
```

ETİKETLER

Delete - Where - Multi Condition -
**Solution 1)**

`Update students set point += 5 where sinif = '10E' and gender = 'E'`

ETİKETLER

Update - Where - Multi Condition -Library Database