w3resource
SQL exercises

SQL: Select specific columns from a table

SQL Basic Select Statement : Exercise-6 with Solution

Write a query to display only name and commission from table salesman.

Sample table: salesman


Sample Solution :

SELECT name, commission
FROM salesman; 

Output of the Query:

name		commission
James Hoog	0.15
Nail Knite	0.13
Pit Alex	0.11
Mc Lyon		0.14
Paul Adam	0.13
Lauson Hen	0.12

Explanation :

Syntax of select specific columns from a table

Pictorial presentation :

Result of select specific columns from a table

Query Visualization:

Duration:

Query visualization of Select specific columns from a table - Duration

Rows:

Query visualization of Select specific columns from a table - Rows

Cost:

Query visualization of Select specific columns from a table - Cost

 

Practice Online


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

Previous: Write a query to display the result of an arithmetic simplification.
Next: Write a query to display salesman_id, salesman name, order date, order no, and purchase amount from orders table.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming