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
order by name
```

**Solution 2)**

```
Select * from students
order by 2
```

ETİKETLER

Select - Order By -
**Solution 1)**

```
Select * from students
where gender = 'M'
order by name
```

**Solution 2)**

```
Select * from students
where gender = 'M'
order by 2
```

ETİKETLER

Select - Where - Order By -
**Solution 1)**

```
Select * from students
order by name desc
```

ETİKETLER

Select - Order By -
**Solution 1)**

```
Select * from students
order by sinif,gender
```

ETİKETLER

Select - Order By -
**Solution 1)**

```
Select * from students
order by newid()
```

ETİKETLER

Select - Order By -
**Solution 1)**

```
Select * from students
where gender = 'M'
order by newid()
```

ETİKETLER

Select - Where - Order By -
**Solution 1)**

```
select * from students
where sinif='10A' and gender='M'
order by newid()
```

ETİKETLER

Select - Where - Order By -
**Solution 1)**

```
Select top 3 * from students
order by newid()
```

ETİKETLER

Select - Top - Order By -
**Solution 1)**

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

ETİKETLER

Select - Top - Where - Order By -
**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 top 1 * from books
order by sayfaSayisi desc
```

**Solution 2)**

```
Select * from books
where sayafaSayisi=(Select max(sayfaSayisi) from books)
```

ETİKETLER

Select - Top - Where - Order By - Sub Query - Aggragate -
**Solution 1)**

```
Select * from students
order by birthdate
```

ETİKETLER

Select - Order By -
**Solution 1)**

```
Insert into authors(name,surname)
Select top 5 name,surname from students order by newid()
```

ETİKETLER

Select - Insert - Top - Order By -
**Solution 1)**

```
Select top 1 students.*,takendate
from students,borrows
where students.studentId = borrows.studentId
order by borrows.takenDate desc
```

**Solution 2)**

```
Select top 1 students.*,takendate
from students
join borrows on students.studentId = borrows.studentId
order by borrows.takenDate desc
```

**Solution 3)**

```
Select students.*,takendate
from students
join borrows on students.studentId = borrows.studentId
where takenDate = (Select max(takenDate) from borrows)
```

ETİKETLER

Select - Top - Join - Where - Order By - Sub Query - Çoklu Tablo -
**Solution 1)**

```
Select name,surname,count(*) BookCount
from students
join borrows on students.studentId = borrows.studentId
group by students.studentId,name,surname
order by BookCount desc
```

**Solution 2)**

```
Select name,surname,count(*) BookCount
from students,borrows
where students.studentId = borrows.studentId
group by students.studentId,name,surname
order by BookCount desc
```

ETİKETLER

Select - Join - Where - Group By - Order By - Aggragate - Alias - Çoklu Tablo -Library Database