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
SELECT * FROM employees WHERE emp_name = 'BLAZE';
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 Tree:
Sample Database: employee
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.
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
- Weekly Trends
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
- Python Tutorial
- Python Array Exercises
- SQL Cross Join
- C# Sharp Array Exercises
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