programming-examples/1. Write a query in SQL to display the full name (first and last name), and salary for those employees who earn below 6000.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

4 lines

233 B

SQL

Raw Permalink Blame History

 /*1. Write a query in SQL to display the full name (first and last name), and salary for those employees who earn below 6000. */
 SELECT first_name ||' '||last_name AS Full_Name, salary
   FROM employees
     WHERE salary < 6000;