w3resource

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:

SELECT *
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)

Explanation:

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:

SELECT name
  FROM random AS r1 JOIN
       (SELECT CEIL(RAND() *
                     (SELECT MAX(id)
                        FROM random)) AS id)
        AS r2
 WHERE r1.id >= r2.id
 ORDER BY r1.id ASC
 LIMIT 1

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