Question

Database: Describe the structure of the SELECT statement with an example.

Answer 1

The structure of the SELECT statement:

SELECT statement is one of the SQL commands.It is used to a query.

Select statement is retrieve the data or select the data from a table in the database.

A query is retrieving the information from particular columns or from all of the columns in the table.

Syntax:

1.select the Particular Column from table:

SELECT column1,column2....... ,FROM tablename;

2.Select the all columns from table:

SELECT * FROM tablename;

Example: Table_name:Customers

CustomerId CustomerName City Country

1 Sony Berlin Germany

2 John Delhi India

3 Thomson London UK

Query Example:

SELECT the particular columns like customerName and Country from Customer table

1. SELECT CustomerName,Country FROM Customers.

Display the Information:

CustomerName Country

Sony Germany

Jhon India

Thomson UK

2.SELECT all columns from Customers Table.

SELECT * FROM Customers;

Display the information:

CustomerId CustomerName City Country

1 Sony Berlin Germany

2 John Delhi India

3 Thomson London UK