SQL Exercise: Display the details of the employee BLAZE

SQL employee Database: Exercise-14 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

14. From the following table, write a SQL query to find the details of the employee ‘BLAZE’.

Sample table: employees

Pictorial Presentation:

SQL exercises on employee Database: Display the details of the employee BLAZE.

Sample Solution:

FROM employees
WHERE emp_name = 'BLAZE';

Sample Output:

 emp_id | emp_name | job_name | manager_id | hire_date  | salary  | commission | dep_id
  66928 | BLAZE    | MANAGER  |      68319 | 1991-05-01 | 2750.00 |            |   3001
(1 row)


The provided query in SQL that selects all columns from the 'employees' table where the emp_name is 'BLAZE'.

The "WHERE" clause filters the results for all employees whose name is 'BLAZE'.

Relational Algebra Expression:

Relational Algebra Expression: Display the details of the employee BLAZE.

Relational Algebra Tree:

Relational Algebra Tree: Display the details of the employee BLAZE.

Practice Online

Sample Database: employee

employee database structure

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

Previous SQL Exercise: Average salaries of the employees works as ANALYST.
Next SQL Exercise: Employees whose commission is more than their salary.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

Follow us on Facebook and Twitter for latest update.

SQL: Tips of the Day

MySQL select 10 random rows from 600K rows fast:

  FROM random AS r1 JOIN
       (SELECT CEIL(RAND() *
                     (SELECT MAX(id)
                        FROM random)) AS id)
        AS r2
 WHERE r1.id >= r2.id

Ref: https://bit.ly/3GdCTM3


We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook