SQL select statement with example

SQL select statement with example

SQL SELECT Statement

The SELECT statement retrieves data from a database.
The data is returned in a table-like structure called a result-set.
SELECT is the most frequently used action on a database.

The SQL SELECT syntax

The general syntax is:

SELECT column-names FROM table-name

To select all columns use *

SELECT * FROM table-name

SQL SELECT Examples

1) select name from person(select one column)

mysql> select name from person;
+-----------------+
| name            |
+-----------------+
| subham ball     |
| jit             |
| sajal           |
| sourav biswas   |
| sajal           |
| chayan das      |
| shantanu biswas |
| sudip saha      |
| debo            |
| NULL            |
| NULL            |
| mono            |
| monojit         |
+-----------------+

2) select name,age from person(select multiple column)

mysql> select name,age from person;
+-----------------+------+
| name            | age |
+-----------------+------+
| subham ball     |   25 |
| jit             |   18 |
| sajal           |   21 |
| sourav biswas   |   23 |
| sajal           |   21 |
| chayan das      |   24 |
| shantanu biswas |   26 |
| sudip saha      |   26 |
| debo            | NULL |
| NULL            | NULL |
| NULL            | NULL |
| mono            |   20 |
| monojit         |   22 |
+-----------------+------+
13 rows in set (0.00 sec)

3) select whole table

mysql> select *from person;
+-----+-----------------+------+------+
| pid | name            | age | sex |
+-----+-----------------+------+------+
| 1   | subham ball     |   25 | M    |
| 10 | jit             |   18 | M    |
| 11 | sajal           |   21 | M    |
| 12 | sourav biswas   |   23 | M    |
| 13 | sajal           |   21 | M    |
| 2   | chayan das      |   24 | M    |
| 3   | shantanu biswas |   26 | M    |
| 4   | sudip saha      |   26 | F    |
| 5   | debo            | NULL | M    |
| 6   | NULL            | NULL | NULL |
| 7   | NULL            | NULL | NULL |
| 8   | mono            |   20 | F    |
| 9   | monojit         |   22 | F    |
+-----+-----------------+------+------+
13 rows in set (0.00 sec)

Comments