PostgreSQL String() Function: Display specific columns for all employees and form the salary column to be left-padded with the dollar
14. Write a query to display the first name and salary for all employees. Form the salary to be 10 characters long, left-padded with the $ symbol. Label the column as SALARY.
SELECT first_name, LPAD(TRIM(TO_CHAR(salary,'9999999')), 7, '$') SALARY FROM employees;
Sample table: employees
pg_exercises=# SELECT first_name, pg_exercises-# LPAD(TRIM(TO_CHAR(salary,'9999999')), 7, '$') SALARY pg_exercises-# FROM employees; first_name | salary -------------+--------- Alexander | $$$9000 Bruce | $$$6000 David | $$$4800 Valli | $$$4800 Diana | $$$4200 Den | $$11000 Alexander | $$$3100 Shelli | $$$2900 Sigal | $$$2800 Steven | $$24000 Neena | $$17000 Guy | $$$2600 Karen | $$$2500 Jason | $$$3300 Michael | $$$2900 Ki | $$$2400 Hazel | $$$2200 Stephen | $$$3200 John | $$$2700 Joshua | $$$2500 Trenna | $$$3500 ... | ... Susan | $$$6500 Hermann | $$10000 Shelley | $$12000 William | $$$8300 (106 rows)
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query that displays the first name and the character length of the first name for all employees whose name starts with the letters 'A', 'J' or 'M'. Give each column an appropriate label. Sort the results by the employees' first names.
Next: PostgreSQL JOINS - Exercises, Practice, Solution
What is the difficulty level of this exercise?
- New Content published on w3resource :
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework