Question

How would you list the title and publication date for each book in the BOOKS table. Use the column heading “Publication Date” for the Pubdate field? Using SQL.

Nane Null? Type ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY NOT NULL VARCHAR2(10) VARCHAR2(30) DATE NUMBER(2) NUMBER(5,2) NUMBER(5,2) NUMBER(1,2) VARCHAR2(12)

Answer 1

SQL QUERY :

SELECT TITLE, PUBDATE AS Publication Date
FROM BOOKS;

Explanation :

The above query displays the columns of the title and the published date

As the question I have changed the Column name from PUBDATE to Publication Date

So the above query will displays the each row by row from the BOOKS table with the columns name as TITLE and Publication Date

AS keyword will replace the column name

SYNTAX :

SELECT COLUMNAME1, COLUMNNAME2, .....

FROM TABLE ;

The above query is the basic syntanx as how we retrieved the values from row by row from the table