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 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 distinct name from students
ETİKETLER
Select - Distinct -Solution 1)
Select distinct class from students
ETİKETLER
Select - Distinct -Solution 1)
Select distinct name, surname from students
ETİKETLER
Select - Distinct -Solution 1)
Select distinct top 5 name from students
ETİKETLER
Select - Top - Distinct -Solution 1)
Select distinct top 3 name from books
ETİKETLER
Select - Top - Distinct -