﻿ SQL - Display all information about all salespeople

# SQL Exercises: Display all information about all salespeople

## SQL Basic Select Statement: Exercise-1 with Solution

Write a SQL statement that displays all the information about all salespeople.

Sample table: salesman

Sample Solution:

SQL Code:

``SELECT * FROM salesman;``

Output of the Query:

```salesman_id	name		city		commission
5001		James Hoog	New York	0.15
5002		Nail Knite	Paris		0.13
5005		Pit Alex	London		0.11
5006		Mc Lyon		Paris		0.14
5003		Lauson Hen	San Jose	0.12
```

Code Explanation:

The said query in SQL that selects all columns from the table 'salesman'. It returns all the rows and columns of the table salesman.

SQL syntax:

```SELECT [DISTINCT] [<qualifier>.]<column_name> |*|
<expression>
[AS <column_alias>],...
FROM <table_or_view_name> |
<inline_view>
[[AS] <table_alias>]
[WHERE <predicate>]
[GROUP BY [<qualifier>.]<column_name>,...
[HAVING <predicate>]
]
[ORDER_BY <column_name> |
<column_number>
[ASC | DESC],...
];
```

Note: Use * to get a complete list of the columns from a table.
Alternate command:
SELECT salesman_id, name, city, commission

Visual presentation:

## Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous SQL Exercise: SQL Retrieve data from tables Exercises Home
Next SQL Exercise: Display a given string.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

﻿

## SQL: Tips of the Day

What is the best way to paginate results in SQL Server?

```SELECT  *
FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY OrderDate ) AS RowNum, *
FROM      Orders
WHERE     OrderDate >= '1980-01-01'
) AS RowConstrainedResult
WHERE   RowNum >= 1
AND RowNum < 20
ORDER BY RowNum
```

Database: SQL Server

Ref: https://bit.ly/3MGrNlk

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook