Download: Download snippet as querys.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!
UPDATE LOAN_HISTORY SET DATE_DUE= '12/25/2013' WHERE LOAN_ID = 'AD331'; UPDATE LOAN_HISTORY SET BOOK_ID = 'LS23' WHERE LOAN_ID = 'AD331'; UPDATE LOAN_HISTORY SET DATE_RETURNED = '' WHERE LOAN_ID = 'AD331'; UPDATE LOAN_HISTORY SET LIBRARIAN_OUT = '1' WHERE LOAN_ID = 'AD331'; UPDATE LOAN_HISTORY SET DATE_ISSUED = '12/11/2013' WHERE LOAN_ID = 'AD331'; COMMIT; SELECT BOOK_ID, AUTHOR.AUTHOR_ID, LAST_NAME, FIRST_NAME FROM BOOK_AUTHOR, AUTHOR WHERE AUTHOR.AUTHOR_ID = BOOK_AUTHOR.AUTHOR_ID; SELECT LOAN_ID, BRANCH_NUM, MEMBER_NUM, BOOK_ID, DATE_ISSUED, LIBRARIAN_OUT, DATE_DUE, DATE_RETURNED, LIBRARIAN_IN, FINE_AMOUNT FROM LOAN_HISTORY WHERE FINE_AMOUNT > 0; SELECT MEMBER_NUM, LAST_NAME, FIRST_NAME FROM MEMBERS ORDER BY LAST_NAME DESC, FIRST_NAME; SELECT MEMBER_NUM, LAST_NAME, FIRST_NAME FROM MEMBERS WHERE MEMBER_NUM IN (SELECT MEMBER_NUM FROM LOAN_HISTORY WHERE LIBRARIAN_OUT = 1); SELECT BRANCH_NUM, SUM(ON_HAND) FROM INVENTOTY GROUP BY BRANCH_NUM;
Create a free my code stock.com account now.
my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!Find out more and register now
You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.