How to see certain table in your database

If you want to see all the columns of the table then write the following code.

SELECT * FROM EMPLOYEE;

The output is given below:


Again if you want to see certain columns of the table then write the following code.

SELECT NAME, ADDRESS
FROM EMPLOYEE;
 
The output is given below:




No comments:

Post a Comment