Scribd
Upload
12 views2 pages

SQL Book Table Commands

Uploaded by

kalraprahas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd
12 views2 pages

SQL Book Table Commands

Uploaded by

kalraprahas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as RTF, PDF, TXT or read online on Scribd

SQL Commands Results

1. Create Table

CREATE TABLE Book (


BookNo INT PRIMARY KEY,
Book_Name VARCHAR(255),
Author VARCHAR(255),
Price DECIMAL(10, 2)
);

2. INSERT AT LEAST 7-8 ROWS

INSERT INTO Book (BookNo, Book_Name, Author, Price) VALUES


(1, ‘adventures of tom marvin’, 'Mark Twain', 18.99),
(2, '1984', ‘Goerge orwell', prahas kalra,15.50),
(3, 'devil may cry', 'Jane Austen', 12.75),
(4, 'BaburNama', 'F. Babar', 10.99),
(5, 'Anand Math, 'BankimChandra', 22.30),
(6, 'Sand and hills', 'james cowell', 25.99),
(7, 'Time Machine', '[Link]', 17.00);

3. Search by Book Number (BookNo = 3)


SELECT * FROM Book WHERE BookNo = 3;

4. Display all Rows


SELECT * FROM Book;

5. Update Price by 10% (BookNo = 4)


UPDATE Book SET Price = Price * 1.10 WHERE BookNo = 4;
6. Display Group by Author

SELECT Author, COUNT(*) as NumberOfBooks


FROM Book
GROUP BY Author;

7. Delete the Row if is Given


DELETE FROM Book WHERE BookNo = 7;

You might also like