[go: up one dir, main page]
Scribd
Upload
12 views2 pages

1 +PracticeExercise+-+Solution

The document describes various SQL queries to retrieve data from database tables: - Questions 1-7 demonstrate basic queries to select columns, rows, filter by conditions using clauses like WHERE, LIMIT, OFFSET, IN - Questions 8-10 filter null and not null values using IS NULL and IS NOT NULL - Questions 11-15 apply pattern matching filters using LIKE operator to match partial column values - Question 16 retrieves only unique values from a column using DISTINCT

Uploaded by

shrutisuman03
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views2 pages

1 +PracticeExercise+-+Solution

The document describes various SQL queries to retrieve data from database tables: - Questions 1-7 demonstrate basic queries to select columns, rows, filter by conditions using clauses like WHERE, LIMIT, OFFSET, IN - Questions 8-10 filter null and not null values using IS NULL and IS NOT NULL - Questions 11-15 apply pattern matching filters using LIKE operator to match partial column values - Question 16 retrieves only unique values from a column using DISTINCT

Uploaded by

shrutisuman03
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

1.

How do you display the values in the "first_name" column of the "employees"
table in SQL?
select first_name from employees;

2. How do you display all the columns and their respective values from the
"employees" table in SQL?
select * from employees;

3. How do you retrieve only 5 rows of data from the "employees" table in SQL?
[Hint: using limit]
select * from employees limit 5;

4. How do you select the employee with the name "Danny Devgan" from the
"employees" table in SQL? [Hint: using where clause]
select * from employees where employee_id = 6;

5. How do you retrieve the employee with employee ID "37" from the
"employees" table (by starting at offset 36 and limiting the result to 1 row) in
SQL? [Hint: using limit, offset]
select * from employees limit 1 offset 36;

6. How do you select the employees from the "employees" table who have an
employee ID ranging from 33 to 38 inclusive in SQL? [Hint: using in operator]
select * from employees where employee_id in (33, 34, 35, 36, 37, 38);

7. How do you use the WHERE clause to filter the "department_name" column in
the "employees" table to only show values of "IT" and "Construction" in
SQL?
select * from employees where department_id in (11, 23);

8. How do you use the WHERE clause to filter the "department_name" column in
the "employees" table to only show values that are not "IT" and
"Construction" in SQL?
select * from departments where department_name not in (11, 23);

9. How do you identify missing "manager_id" values in the "departments" table


in SQL?
select * from departments where manager_id is null;

Proprietary content. © Great Learning. All Rights Reserved. Unauthorized use or distribution
prohibited.
10. How do you retrieve only the non-NULL values of the "manager_id" column
from the "departments" table in SQL?
select * from departments where manager_id is not null;

11. How do you retrieve the values of the "first_name" column in the "employees"
table that start with "sh" in SQL?
select * from employees where first_name like "Sh%";

12. How do you select only last_name those ending with "ra" in SQL?
select * from employees where last_name like "%ra";

13. How do you retrieve the values of the "last_name" column in the "employees"
table that end with "ra" in SQL?
select * from employees where hire_date like "%04%";

14. How do you retrieve the information of the employee in the "employees" table
whose "first_name" starts with "sa" and ends with "a" in SQL?
select * from employees where first_name like "Sa%" and last_name like "%a";

15. How do you retrieve information of employees from the "employees" table
that do not have "sharma" as their "last_name" in SQL?
select * from employees where last_name not like "sharma";

16. How do you retrieve the unique values of the "last_name" column in the
"employees" table in SQL?
select distinct last_name from employees;

Proprietary content. © Great Learning. All Rights Reserved. Unauthorized use or distribution
prohibited.

You might also like