1
00:00:04,220 --> 00:00:05,990
Hello and welcome to this video.

2
00:00:06,010 --> 00:00:12,660
In the previous video, we have created a table by the name implies we have added rerecords into it.

3
00:00:13,130 --> 00:00:15,740
So now let's complete the lab exercise.

4
00:00:15,740 --> 00:00:24,700
So the first exercises find the name of all the employees, so I'll quickly go to the localhost and

5
00:00:25,010 --> 00:00:31,720
a query that is select staff from employees, which is going to give me all the records from the employees

6
00:00:31,730 --> 00:00:32,200
table.

7
00:00:32,720 --> 00:00:39,890
So the second thing is list all the employees who are working in I.T. So how to do that?

8
00:00:39,900 --> 00:00:46,820
We have discussed it previously that if you want to put any condition, we can use some conditional

9
00:00:46,820 --> 00:00:49,300
clause such as their clause.

10
00:00:49,760 --> 00:00:54,320
So now we are going to go on to the localhost, go to a school.

11
00:00:55,170 --> 00:01:01,440
And we want to fetch all the different records present in the employees stable where?

12
00:01:02,280 --> 00:01:10,860
Employee department is equal to I.T., so it is going to give me all the records present in the table

13
00:01:10,870 --> 00:01:15,050
who all walks in to the city department head, don't go.

14
00:01:15,070 --> 00:01:15,600
You'll see.

15
00:01:15,600 --> 00:01:23,270
The result is only Heti is the person from the whole employee's table who works in the I.T. department.

16
00:01:23,280 --> 00:01:26,460
So I am getting the result as such.

17
00:01:27,750 --> 00:01:34,880
So now moving on, the third question is sure, different types of departments, so how to find out

18
00:01:34,920 --> 00:01:43,920
different types of department present, so select distinct the column name that is employed department

19
00:01:44,100 --> 00:01:45,710
from employee stable.

20
00:01:46,500 --> 00:01:52,510
So this is the key word used to find out the unique values present in a particular column.

21
00:01:52,980 --> 00:02:00,380
So we are going to find out the different departments present in the table, employees.

22
00:02:00,390 --> 00:02:07,950
So you see there are three different departments that has been Enzyte in H.R. So this is the solution

23
00:02:07,950 --> 00:02:12,670
of all the three exercises which I have given you, you can practice a lot more.

24
00:02:12,690 --> 00:02:19,960
There are so many resources around the Internet so you can find out such questions and practice on yourself.

25
00:02:20,370 --> 00:02:22,050
So that's it for this video.

26
00:02:22,080 --> 00:02:23,220
Thank you so much.
