Select Query in SQL

After executing above sql file, all the tables in the library database have few records. Now how do we see these inserted records from the tables? We have to use SELECT query to get the data.

SELECT * FROM AUTHOR; — displays all the records from AUTHOR table

SELECT * FROM PUBLISHER;
SELECT * FROM CATEGORY;
SELECT * FROM BORROWER;
SELECT * FROM BOOKS;
SELECT * FROM BOOK_AUTHOR;
SELECT * FROM BOOK_CATEGORY;
SELECT * FROM BOOK_COPY;
SELECT * FROM BOOK_LOAN;

 

Translate ยป