In this page there are more than 100 Sql Query Examples With Answers. You can find any examples easily with sql query search engine. To use it will be very interesting for you. If you want to solve the queries, you can download the sample library database with more than 10000 records data. To download the database click here.

**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
where name like '%a_'
```

ETİKETLER

Select - Where - Like -
**Solution 1)**

```
Delete from students
where name = 'Gray'
```

ETİKETLER

Delete - Where -
**Solution 1)**

`Select count(*) from books`

**Solution 2)**

`Select count(bookId) from books`

ETİKETLER

Select - Aggragate -
**Solution 1)**

```
Create procedure factor(@number int)
as begin
Declare @i int = 1,@result int=1
while (@i<=@number)
Begin
Set @result = @result * @i
Set @i += 1
End
Select @result
End
```

ETİKETLER

Procedure - Declare -
**Solution 1)**

```
Select count(*) from students
where sinif = '9B'
```

ETİKETLER

Select - Where - Aggragate -
**Solution 1)**

```
Select Year(takendate) as Year, datepart(qq,takendate) as Quarter,count(*) as Count
from borrows
group by Year(takendate),datepart(qq,takendate)
```

ETİKETLER

Select - Group By - SQL Functions -
**Solution 1)**

`Select name + surname from students`

**Solution 2)**

`Select name + surname as ns from students`

**Solution 3)**

`Select name + ' ' + surname as ns from students`

ETİKETLER

Select - Alias -
**Solution 1)**

```
Create Procedure sp_isPrime (@number int,@result bit output) as
Begin
Set @result = 1
Declare @i int = 2
While (@i<@number)
Begin
if(@number % @i = 0)
Begin
Set @result = 0
break
End
Set @i += 1
End
retypesn @result
End
--To Execute The Stroed Procedure
Declare @result bit
Execute sp_isPrime 11,@result output
Select @result
```

ETİKETLER

Procedure - Declare -
**Solution 1)**

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

ETİKETLER

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

```
Select students.name as OgrenciAd,
students.surname,books.name as KitapAd,
takenDate,types.name as TurAd
from students,borrows,books,types
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
books.typeId = types.typeId
```

**Solution 2)**

```
Select students.name as studentName,
students.surname,books.name as BookName,
takenDate,types.name as TypeName
from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
join types on books.typeId = types.typeId
```

ETİKETLER

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

`Update students set name = 'Süleyman' where studentId = 20`

ETİKETLER

Update - Where -
**Solution 1)**

```
Select * from students
where name like '%a'
```

ETİKETLER

Select - Where - Like -
**Solution 1)**

`Delete from books`

ETİKETLER

Delete -
**Solution 1)**

```
Update students set name='Veli'
where name = 'Ali'
```

ETİKETLER

Update - Where -
**Solution 1)**

```
Delete from students
where studentId = 5
```

ETİKETLER

Delete - Where -
**Solution 1)**

`Update students set sinif = '10C' where studentId between 20 and 30`

ETİKETLER

Update - Where - Between -
**Solution 1)**

```
Select sinif,count(*) as StudentCount
from students
group by sinif
having count(*) >= 30
```

ETİKETLER

Select - Group By - Having - Alias -
**Solution 1)**

```
Create Procedure myPower(@num int,@pow int, @result int output) As
Begin
Declare @i int = 0;
Set @result = 1
while(@i<@pow)
Begin
Set @result = @result * @num
Set @i += 1
End
End
```

ETİKETLER

Procedure - Declare -
**Solution 1)**

```
Insert into authors
values('x','y')
```

**Solution 2)**

```
Insert into authors(name,surname)
values('x','y')
```

ETİKETLER

Insert -
**Solution 1)**

`Select avg(point) from students`

ETİKETLER

Select - Aggragate -
**Solution 1)**

```
Create Procedure sp_Devide(@n1 int,@n2 int,@division int output,@remaining int output) as
Begin
SEt @division = 0
While(@n2<=@n1)
Begin
Set @n1 = @n1-@n2
Set @division+=1
End
Set @remaining = @n1
End
--To Execute the Stored Procedure
Declare @d int,@r int
Execute sp_Devide 34,7,@d output,@r output
Select @d Division,@r Remaining
```

ETİKETLER

Procedure - Declare -
**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)**

```
Update books set point += 1
where typesno = (Select typesno from books where name = 'Dram')
```

**Solution 2)**

```
Update books set point += 1
where typesno in (Select typesno from books where name = 'Dram')
```

ETİKETLER

Update - Where - Sub Query -
**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 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)**

`Delete from borrows`

ETİKETLER

Delete -
**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 name,surname,takenDate from students,borrows
where students.studentId = borrows.studentId
```

**Solution 2)**

```
Select name,surname,takenDate from students
join borrows on students.studentId = borrows.studentId
```

ETİKETLER

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

```
Update books set point +=10
where pagecount = (Select MAX(pagecount) from books)
```

ETİKETLER

Update - Where - Sub Query - Aggragate -
**Solution 1)**

```
Select * from students
where studentId % 2 = 1
```

ETİKETLER

Select - Where -
**Solution 1)**

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

ETİKETLER

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

```
Delete from students
where studentId not in
(Select studentId from borrows)
```

ETİKETLER

Delete - Where - Sub Query -
**Solution 1)**

```
Select sum(pageCount) from books
join authors on authors.authorId = books.authorId
where authors.name = 'John' and authors.surname = 'DosPassos'
```

ETİKETLER

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

```
Delete from students
where studentId in (Select studentId from borrows
group by studentId
having count(*)<5)
```

ETİKETLER

Delete - Where - Group By - Having - Sub Query -
**Solution 1)**

```
Select count(*) from books
join types on types.typeId = books.typeId
where types.name = 'Horror'
```

ETİKETLER

Select - Join - Where - Aggragate - Çoklu Tablo -
**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'
```

**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'
```

ETİKETLER

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

```
Select * from students
where name like '%a%'
```

ETİKETLER

Select - Where - Like -
**Solution 1)**

```
Select students.* from students
left join borrows on students.studentId = borrows.studentId
where borrowsno is null
```

**Solution 2)**

```
Select * from students
where studentId not in
(Select studentId from borrows)
```

ETİKETLER

Select - Where - Sub Query - Çoklu Tablo - Left Join -
**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 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)**

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

ETİKETLER

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

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

ETİKETLER

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

`Select sum(pageCount) from books`

ETİKETLER

Select - Aggragate -
**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 * from students
order by name desc
```

ETİKETLER

Select - Order By -
**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 ("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 students`

ETİKETLER

Select -
**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 -
**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 name,surname,count(borrowsno) BookCount
from students
left join borrows on students.studentId = borrows.studentId
group by students.studentId,name,surname
order by BookCount
```

**Solution 2)**

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

ETİKETLER

Select - Top - Where - Having - Sub Query -
**Solution 1)**

`Select avg(pageCount) from books`

ETİKETLER

Select - Aggragate -
**Solution 1)**

```
Select sinif,gender,count(*) as StudentCount
from students
group by gender,sinif
```

ETİKETLER

Select - Group By - Aggragate - Alias -
**Solution 1)**

`Select count(*) from students`

**Solution 2)**

`Select count(studentId) from students`

ETİKETLER

Select - Aggragate -
**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)**

```
Select * from students
where name like '_a%'
```

ETİKETLER

Select - Where - Like -
**Solution 1)**

`Update books set point +=5`

**Solution 2)**

`Update books set point = point + 5`

ETİKETLER

Update -
**Solution 1)**

```
Select students.name as studentName,
students.surname,books.name as BookName,
takenDate,types.name as TypeName,
authors.name as AuthorName, authors.surname as AuthorSurname
from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
join types on books.typeId = types.typeId
join authors on authors.authorId = books.authorId
```

**Solution 2)**

```
Select students.name as studentName,students.surname,
books.name as BookName,takenDate,types.name as TypeName ,
authors.name as AuthorName,authors.surname as AuthorSurname
from students, borrows, books, types, authors
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId and
books.typeId = types.typeId and
authors.authorId = books.authorId
```

ETİKETLER

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

```
Select * from books
where bookId like '%1%'
```

ETİKETLER

Select - Where - Like -
**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 * from students
where studentId=1 or studentId=7 or
studentId=11 or studentId=17
```

**Solution 2)**

```
select * from student
where studentId in (1,7,11,17)
```

ETİKETLER

Select - Where -
**Solution 1)**

```
Insert into students(name,surname)
Select name,surname from authors
```

ETİKETLER

Select - Insert -
**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 top 1 * from students
where sinif= '10A'
order by newid()
```

ETİKETLER

Select - Top - Where - Order By -
**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 sinif,count(*) as StudentCount
from students
group by sinif
```

ETİKETLER

Select - Group By - Aggragate -
**Solution 1)**

```
Select * from books
where bookId in(3,4,8,9,11,23)
```

**Solution 2)**

```
Select * from books
where bookId = 3 or
bookId = 4 or
bookId = 8 or
bookId = 9 or
bookId =11 or
bookId = 23
```

ETİKETLER

Select - Where -
**Solution 1)**

```
Insert into students
values ('x','y',null,null,null,null)
```

**Solution 2)**

```
Insert into students(name,surname)
values ('x','y')
```

ETİKETLER

Insert -
**Solution 1)**

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

ETİKETLER

Select - Where - Order By -
**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 avg(pageCount) from books
join types on types.typeId = books.typeId
where types.name = 'Comics'
```

ETİKETLER

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

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

ETİKETLER

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

```
Create procedure randomGenerate(@unit int,@min int,@max int)
as
Begin
Declare @numbers table(number int)
Declare @i int = 0
Declare @number int
while (@i<@unit)
Begin
Set @number = floor(rand()*(@max-@min+1))+@min
if(not exists(Select * from @numbers where number = @number))
begin
insert into @numbers values(@number)
Set @i = @i + 1
end
end
Select * from @numbers order by 1
End
--To Execute Stored Procedure
Execute randomGenerate 5,20,30
```

ETİKETLER

Select - Insert - Procedure - Declare -
**Solution 1)**

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

ETİKETLER

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

```
Select sum(pageCount) from books
join types on types.typeId = books.typeId
where types.name = 'Romance'
```

ETİKETLER

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

```
Select Year(birthdate) as Year, datepart(qq,birthdate) as Quarter,count(*) as Count
from students
group by Year(birthdate),datepart(qq,birthdate)
```

ETİKETLER

Select - Group By - SQL Functions - Alias -
**Solution 1)**

`Select sum(point) from students`

ETİKETLER

Select - Aggragate -
**Solution 1)**

```
Create Procedure sumThree
@n1 int,
@n2 int,
@n3 int,
@result int output as
Begin
Set @result = @n1+@n2+@n3
End
--To Execute The Procedure
Declare @result int
Execute sumThree 5,30,12,@result output
Select @result
```

ETİKETLER

Procedure - Declare -
**Solution 1)**

`Update students set name = 'Arzu', surname = 'Çelik' where studentId = 24`

ETİKETLER

Update - Where -
**Solution 1)**

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

ETİKETLER

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

```
Create Procedure AddTwoNumber(@p1 int,@p2 int,@Result int output)
as
Begin
Set @Result = @p1+ @p2
End
--To Execute The Procedure
Declare @r int
Execute AddTwoNumber 20,25,@r output
Select @r as Result
```

ETİKETLER

Procedure - Declare -
**Solution 1)**

```
Select * from students
where name like 'a%'
```

ETİKETLER

Select - Where - Like -
**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)**

```
Create Procedure Sp_Random_Value
@first int,
@second int,
@result int output
As
Begin
Set @result =Floor(RAND() * (@second-@first))+@first
End
--To Execute the Procedure
Declare @r int
Execute Sp_Random_Value 20,30,@r output
Select @r
```

ETİKETLER

Procedure - Declare -
**Solution 1)**

```
Insert into authors(name,surname)
select name,surname from students
where sinif='9A' and gender='M'
```

**Solution 2)**

```
Insert into authors
select name,surname from students
where sinif='9A' and gender='M'
```

ETİKETLER

Select - Insert - Where -
**Solution 1)**

```
Insert into students(name,surname,sinif)
Select name,surname,'12M' from authors where name like '%a%'
```

ETİKETLER

Select - Insert - Where -
**Solution 1)**

```
Delete from books
where pageCount between 50 and 100
```

**Solution 2)**

```
Delete from books
where pagecount<=100 and pagecount>=50
```

ETİKETLER

Delete - Where -
**Solution 1)**

`Update students set point=100`

ETİKETLER

Update -
**Solution 1)**

`Select max(point) from books`

ETİKETLER

Select - Aggragate -
**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 books.* from books
left join borrows on books.bookId = borrows.bookId
where borrowsno is null
```

**Solution 2)**

```
Select * from books
where bookId not in
(Select bookId from borrows)
```

ETİKETLER

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

`Select * from books`

ETİKETLER

Select -
**Solution 1)**

```
Select * from students
where name =
```*'Bill'*

ETİKETLER

Select - Where -
**Solution 1)**

```
Select gender,count(*) as StudentCount
from students
group by gender
```

ETİKETLER

Select - Group By - Aggragate - Alias -
**Solution 1)**

`Select min(pageCount) from books`

ETİKETLER

Select - Aggragate -
**Solution 1)**

```
Insert into authors(name,surname)
values('Ernest','Dowson'),
('Mother','Goose')
```

**Solution 2)**

```
Insert into authors
values ('Ernest','Dowson'),
('Mother','Goose')
```

ETİKETLER

Insert -
**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 books
where bookId % 2 = 0
```

ETİKETLER

Select - Where -
**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 sinif,gender,count(*) as StudentCount
from students
where gender = 'F'
group by gender,sinif
```

ETİKETLER

Select - Where - Group By - Aggragate - Alias -
**Solution 1)**

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

ETİKETLER

Select - Order By -
**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 students.name,students.surname,books.name,takenDate
from students,borrows,books
where students.studentId = borrows.studentId and
books.bookId = borrows.bookId
```

**Solution 2)**

```
Select students.name,students.surname,books.name,takenDate from students
join borrows on students.studentId = borrows.studentId
join books on books.bookId = borrows.bookId
```

ETİKETLER

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

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

**Solution 2)**

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

ETİKETLER

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