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.
7 lines
431 B
SQL
7 lines
431 B
SQL
/*6. Write a query in SQL to display the full name (first and last), hire date, salary, and department number for those
|
|
employees whose last name does not containing the letter M and make the result set in ascending order by department number.*/
|
|
SELECT first_name || ' ' || last_name as Full_Name, hire_date,
|
|
salary, department_id
|
|
FROM employees
|
|
WHERE first_name NOT LIKE '%M%'
|
|
ORDER BY department_id; |