﻿ 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

A table name as a variable -

For static queries, like the one in your question, table names and column names need to be static.

For dynamic queries, you should generate the full SQL dynamically, and use sp_executesql to execute it.

Static query:

```SELECT * FROM [DB_ONE].[dbo].[ACTY]
EXCEPT
SELECT * FROM [DB_TWO].[dbo].[ACTY]
```

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

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