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
Pictorial presentation :
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?