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)
Delete from students
where studentId = 5
ETİKETLER
Delete - Where -Solution 1)
Delete from books
ETİKETLER
Delete -Solution 1)
Delete from borrows
ETİKETLER
Delete -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)
Delete from students
where studentId not in
(Select studentId from borrows)
ETİKETLER
Delete - Where - Sub Query -Solution 1)
Delete from students
where name = 'Gray'
ETİKETLER
Delete - 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 in (Select studentId from borrows
group by studentId
having count(*)<5)
ETİKETLER
Delete - Where - Group By - Having - Sub Query -