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.