SQL Practice Session 13 April 2025

RAKESH KUMAR

SQL Practice Session 13 April 2025  https://drive.google.com/file/d/1yM0sPXQdQBo4FL6wBNvw-OFnN_3704QO/view?usp=sharing

Transcript

00:00:00so practice to do something

00:00:05we will do something today

00:00:07create database

00:00:10April 13

00:00:172025

00:00:21how many questions

00:00:23we have been asked

00:00:27we have been asked

00:00:2931

00:00:30Sanjeev

00:00:31yes

00:00:33we will see

00:00:35we will see

00:00:37let's see

00:00:39let's see

00:00:4131

00:00:4331

00:00:4531

00:00:4731

00:00:4931

00:00:5131

00:00:5331

00:00:5531

00:00:5631

00:00:5831

00:01:0031

00:01:0132

00:01:0232

00:01:0332

00:01:0432

00:01:0533

00:01:0633

00:01:0734

00:01:0833

00:01:0934

00:01:1033

00:01:1133

00:01:1334

00:01:1435

00:01:1534

00:01:1635

00:01:1735

00:01:1935

00:01:2035

00:01:2135

00:01:2237

00:01:2435

00:01:25कि अब सरे रहे हैं तो कि दिपक फिर से connect कर लो

00:01:35कि कुछ sound me so hooga या जो network में तो यही होता है न अनलाइन

00:01:43is

00:01:45the

00:01:47one

00:01:49number

00:01:51is

00:01:53import

00:01:55is

00:01:57is

00:01:59is

00:02:01is

00:02:03is

00:02:05is

00:02:07I said that I had a class from 20 to 20, but now I have 15 people in the classroom.

00:02:21Because there were almost 100 people in the classroom, so I have done this table.

00:02:31insert

00:02:36is

00:02:36a

00:02:36code table

00:02:37department

00:02:40is

00:02:41my record

00:02:42is

00:02:42so

00:02:42I

00:02:42have

00:02:42a

00:02:43a

00:02:44a

00:02:45a

00:02:46a

00:02:47a

00:02:48a

00:02:49a

00:02:50a

00:02:51a

00:02:52a

00:02:53a

00:02:54a

00:02:55a

00:02:56a

00:02:57a

00:02:58a

00:02:59a

00:03:00a

00:03:01a

00:03:01connection

00:03:02nigh ho

00:03:03select

00:03:12start

00:03:13form

00:03:14e.m.p

00:03:14select

00:03:17start

00:03:19form

00:03:20dpt

00:03:22okay

00:03:24come to

00:03:26question

00:03:26the connection to the other but this is it's a little question like the higher

00:03:38I am going to ask you a question.

00:03:45Yes, go to Dipak.

00:03:50Yes, Dipak has some connection.

00:03:57It's a sad thing.

00:04:01If you know it, easy.

00:04:04If you don't know it, simple.

00:04:07I will save it.

00:04:10I will save it.

00:04:22I will save it.

00:04:26I will save it.

00:04:32I will save it.

00:04:35I will save it.

00:04:37I will save it.

00:04:52display all the employees who are getting some commission in marketing department where

00:04:59the employees have joined only big-end

00:05:03marketing tomorrow marketing तो है तो कि सेल्स-सने��어 सेल्स-समें आणका कर लेंगा याई तो अच्छा नहीं

00:05:25रिकोर्डिंग रुक़िया वहाई पता है कि लल वाल बंदा

00:05:33display all the employees who are getting more than average salary of all employees

00:05:42which means that the salary of all employees will be more than average salary of all employees

00:05:58then you can select only case the average

00:06:02then wrong ENP be so get that new different awesome to meet you to our

00:06:20case of select star from CLP where 30 greater than equal to greater than

00:06:43the same number of groups are in a bracket

00:06:51these are all the people whose salary are more than average

00:06:58average salary when our work is small in the curie practices will be better

00:07:05then make an easy way

00:07:08make it equal join

00:07:10this question is written on assignment of equi join

00:07:20display all the managers and clerks who are working in account and marketing department

00:07:35and marketing department

00:07:48question

00:07:50sir

00:07:53is

00:08:00marketing

00:08:02yes

00:08:04yes

00:08:06but

00:08:08the

00:08:10the

00:08:12the

00:08:14the

00:08:16the

00:08:18the

00:08:20the

00:08:22the

00:08:24the

00:08:26the

00:08:28and

00:08:30the

00:08:32the

00:08:34the

00:08:36select

00:08:38the

00:08:40the

00:08:42the

00:08:44the

00:08:46the

00:08:48the

00:08:50the

00:08:52the

00:08:54the

00:08:56Okay, let's go ahead and tell you how to do it.

00:09:02Okay, sir, you will use the MP department.

00:09:08How do you write it?

00:09:14How do you write it?

00:09:17Yes, sir, where?

00:09:21Yes, sir, the name.

00:09:27Yes, sir.

00:09:30Yes, sir.

00:09:33Yes, sir.

00:09:35Yes, sir.

00:09:38Yes, sir.

00:09:43Yes, sir.

00:09:49Yes, sir.

00:09:50Yes, sir.

00:09:53Yes, sir.

00:09:55Yes, sir.

00:09:56Yes, sir.

00:09:57Yes, sir.

00:09:58Yes, sir.

00:09:59We have to correct this file, the name.

00:10:02Yes, sir, sir.

00:10:04सuka नहीं हुं स्ERथ सिर्फी दिपार्टमेंट एनुलोrons तो हिए ना सा उस्ञाइड

00:10:1010 दह सर्थ 30 इस को के करते हैं और यहँ पर लिखते हैं Select

00:10:20अ सो मेनेजर का नाम निका सब्सक्राइड इन एक नगे

00:10:27from EMP of I'm sorry we have to do here also now I'm going to get on time for the

00:10:39header in in a mission department deputy in the class deputy and no

00:10:48project manager and clerk and manager and clerk and manager and clerk has

00:11:13and job in

00:11:18and job in

00:11:21clerk and manager

00:11:28I am

00:11:30I

00:11:32I

00:11:34I

00:11:36I

00:11:38I

00:11:40I

00:11:42I

00:11:44I

00:11:46I

00:11:48I

00:11:50I

00:11:52I

00:11:54I

00:11:56I

00:11:58I

00:12:00I

00:12:02I

00:12:04I

00:12:06I

00:12:08I

00:12:10I

00:12:12I

00:12:14I

00:12:16I

00:12:18I

00:12:20I

00:12:22I

00:12:24I

00:12:26I

00:12:28I

00:12:30I

00:12:32I

00:12:34I

00:12:36I

00:12:38I

00:12:40I

00:12:42I

00:12:44I

00:12:46I

00:12:48I

00:12:50I

00:12:52I

00:12:54I

00:12:56I

00:12:58I

00:13:00I

00:13:02I

00:13:04I

00:13:06I

00:13:08I

00:13:10I

00:13:12I

00:13:14I

00:13:16I

00:13:18I

00:13:20I

00:13:22I

00:13:24I

00:13:26I

00:13:28I

00:13:30I

00:13:32I

00:13:34I

00:13:36I

00:13:38I

00:13:40I

00:13:42I

00:13:44I

00:13:46I

00:13:48I

00:13:50I

00:13:52I

00:13:54I

00:13:56I

00:13:58I

00:14:00I

00:14:02I

00:14:04I

00:14:06I

00:14:08I

00:14:10I

00:14:14I

00:14:16I

00:14:18I

00:14:20I

00:14:22I

00:14:24I

00:14:26I

00:14:28I

00:14:30I

00:14:32I

00:14:34I

00:14:36I

00:14:38I

00:14:40I

00:14:42I

00:14:44I

00:14:46I

00:14:48I

00:14:50I

00:14:52I

00:14:54I

00:14:56I

00:14:58I

00:15:00I

00:15:02I

00:15:04I

00:15:06I

00:15:08I

00:15:10I

00:15:12I

00:15:14I

00:15:16I

00:15:18I

00:15:20I

00:15:22I

00:15:24I

00:15:26I

00:15:28I

00:15:30I

00:15:32I

00:15:34I

00:15:36I

00:15:38I

00:15:40I

00:15:42I

00:15:44I

00:15:46I

00:15:48I

00:15:50I

00:15:52I

00:16:02I

00:16:03I

00:16:05I

00:16:07I

00:16:09I

00:16:11I

00:16:13I

00:16:15I

00:16:17I

00:16:19I

00:16:21I

00:16:23I

00:16:25I

00:16:27I

00:16:29I

00:16:31I

00:16:32I

00:16:33I

00:16:56I

00:16:57I

00:16:59So, let's get started.

00:17:59Hmm, but I have a fear

00:18:20Screen there is

00:18:23Screen there is

00:18:25There is

00:18:26Okay, okay, okay, okay, okay, okay, okay, okay, okay, okay, okay, okay, okay, okay,

00:18:45hmm, so here we have to give you a select e.ename, e.job, d.department from EMP here,

00:18:53here we have to call all salesmen who are not located at Dulse, all salesmen, so here we have to

00:19:01go, department, d.name, salesmen, d.lockdown location, we will see,

00:19:12what was it?

00:19:16This is the last one, D.lock, lock, and

00:19:21there is no other stuff here, here you have to add a whole, D.loc,

00:19:28much to check it hello see not equal to I say correct in D L a s Dallas and he

00:19:48dot you know the requirement and all salesman has salesman being all salesman

00:19:59you don't you don't do it equal to salesman salesperson a key man

00:20:14is what some of us is this little thing I got to take other salesman

00:20:24I am looking here after this guy I was a sounder I don't know the purpose of this

00:20:33I'm a part of it is the department in the area D dot name I'm not here I am a

00:20:40that LOC.

00:20:41These are all the names of the people who work in the city, which do not belong to the city,

00:20:57This will be salesmen , so if I remove salesmen, then let me see here

00:21:10कि यह ओ सारे लोग है जो किसी ने किसी जॉब में है और डर्ट रेंड़ाश सीटी में नहीं है ठिक

00:21:18हो ग्रेंग ए है कि अंगे सिर्ट कि क्वेस्ट्टन छोटे फडर मत जाना संजीब कॉस्टन तो बड़े आंगे बड़े भी आएंगे लेकिन छोटे एक वार क्लियर तो

00:21:40Oh

00:21:43Oh

00:21:45okay

00:21:47I

00:21:50I

00:21:51I

00:21:53I

00:21:56I

00:21:57I

00:21:58I

00:22:00I

00:22:01I

00:22:03I

00:22:05I

00:22:07I

00:22:08I

00:22:10this is what we are doing.

00:22:14Tell us about this.

00:22:18What will we do next?

00:22:22What is the problem?

00:22:26We are going to join.

00:22:30Don't join one step.

00:22:34Don't join one step.

00:22:36Don't join one step.

00:22:40Don't join one step.

00:22:42Don't join one step.

00:22:44Don't join one step.

00:22:46Don't join another step.

00:22:48Tell us how to do it.

00:22:50Select

00:22:52E.Name

00:22:56E.Name

00:23:00Where is it?

00:23:02E.Name

00:23:04E.Name

00:23:06E.Name

00:23:08No.

00:23:10We need the person's name.

00:23:12The person's name is the person's name.

00:23:14The person's name is the person's name.

00:23:16Okay.

00:23:18We have to name the person's name.

00:23:20It will be easy to understand.

00:23:22Okay.

00:23:24Select E.Name

00:23:26E.Name

00:23:28E.Name

00:23:30E.Name

00:23:31E.Name

00:23:32E.Name

00:23:33E.Name

00:23:34E.Name

00:23:35E.Name

00:23:36E.Name

00:23:37E.Name

00:23:38E.Name

00:23:39E.Name

00:23:40E.Name

00:23:41E.Name

00:23:42E.Name

00:23:43E.Name

00:23:44E.Name

00:23:45E.Name

00:23:46E.Name

00:23:47E.Name

00:23:48E.Name

00:23:49E.Name

00:23:50E.Name

00:23:51E.Name

00:23:52E.Name

00:23:53E.Name

00:23:54E.Name

00:23:55E.Name

00:23:56E.Name

00:23:57Oh, what's the department in my name name be to her D name be to her

00:24:05Oh, I think I said you don't depart from

00:24:11Yes, I want to come out of it

00:24:14Oh, but I'll see you from EMP

00:24:18Oh, so join yeah, please join your inner join quick for that. Yeah, sir.

00:24:24EMP me era visitor is called nice name a hopper dpt d her on a vehicle as a

00:24:36take a take away here on the field of e dot this case but a lot of dpt no dpt no

00:24:53e dot

00:24:56equal to d dot dpt

00:24:58If I do this, it's just so much.

00:25:07And what is the question?

00:25:09Who implies who is working for color?

00:25:15We didn't have this thing.

00:25:17Where?

00:25:19e.job

00:25:23e.job

00:25:25We are working for the clerk.

00:25:30No, no.

00:25:32Who is working for the clerk?

00:25:35The clerk is a person.

00:25:37Sorry.

00:25:39So, this will be the case for this.

00:25:43Select.

00:25:45Tell me, brother.

00:25:48There is a boundless file.

00:25:52Let's see.

00:25:54Select.

00:25:56Star.

00:25:57Star.

00:25:58From.

00:25:59Star.

00:26:00From.

00:26:01E.M.P.

00:26:02Where.

00:26:03Are you?

00:26:05I think I have no idea.

00:26:07First, we need to remove the ID of the Colarch.

00:26:11Yes.

00:26:13And then, we need to remove the ID of the Colarch.

00:26:18Why do we need to remove the Colarch?

00:26:21First, we need to remove the Colarch.

00:26:26We need to remove the name of the Colarch.

00:26:31Select the EMP.

00:26:36EMP.

00:26:38EMP.

00:26:39EMP.

00:26:40EMP.

00:26:41EMP.

00:26:42Where.

00:26:43E.

00:26:44Name.

00:26:45Is.

00:26:46Colarch.

00:26:487782.

00:26:50Okay?

00:26:51Now, 7782.

00:26:52Okay?

00:26:53Now, 7782.

00:26:57Now, we need to remove the manager.

00:27:01We need to remove 7782.

00:27:03Is.

00:27:04Is.

00:27:05Is.

00:27:06Is.

00:27:07Is.

00:27:08mgr

00:27:11is equal to

00:27:16is equal to

00:27:17is equal to

00:27:18is equal to

00:27:19copy

00:27:19and paste

00:27:21now

00:27:21let's see

00:27:24Miller

00:27:27is equal to

00:27:28is equal to

00:27:29color

00:27:31is equal to

00:27:31color

00:27:32is equal to

00:27:32color

00:27:33is equal to

00:27:34and

00:27:34just

00:27:36one

00:27:37is equal to

00:27:38is equal to

00:28:01let's start

00:28:02from

00:28:02where

00:28:03mgr

00:28:05is equal to

00:28:06seven seven eight two take a Miller in here and so you have an nickel

00:28:13Gaia but it's not a Miller job have color department name accounting

00:28:18location and Newark is Miller के लिए काम करता है मतलब इसका

00:28:22बहुत मिलर है and clear yes

00:28:28people questions 37

00:28:41select all the departmental information for all the manager

00:28:47departmental information make a key I got a location of your upka

00:28:58calling a happy depart department name of the department number department name or location

00:29:08on this select all department information for all all the manager

00:29:14I got a c-mail करें to select a dot

00:29:23hey I'm not a rune-do

00:29:28a or the E P T N O

00:29:33कि यहां पर हो गया department नम्मर

00:29:35take care was gave our department name or department alone location head ticket

00:29:45you have to take care of condition can legal look over select all the part of your time for

00:29:56know for all the manager huh where he don't go equal to manager e dot job equal to manager bus

00:30:19go as far from에게 manager pins in business in your logo and hold on from the days a gewesen

00:30:41people who are the manager in the sub department, the location is here, you can see the manager

00:30:49three of them, one, two, three, three, so this is all, these are the manager's information

00:31:08is

00:31:11that

00:31:12name

00:31:13and job

00:31:14and location

00:31:17and location

00:31:18and

00:31:19this

00:31:20is

00:31:21now

00:31:23it is

00:31:24fast

00:31:25fast

00:31:26fast

00:31:27fast

00:31:28fast

00:31:29fast

00:31:30fast

00:31:31fast

00:31:32fast

00:31:33fast

00:31:34fast

00:31:35fast

00:31:36fast

00:31:37and

00:31:39name

00:31:40and

00:31:41job

00:31:42and

00:31:43location

00:31:44and

00:31:45and

00:31:46here

00:31:47and

00:31:48here

00:31:49is

00:31:50ok

00:31:51ok

00:31:52ok

00:31:53ok

00:31:54ok

00:31:55ok

00:31:56ok

00:31:57ok

00:31:58ok

00:31:59ok

00:32:00ok

00:32:02ok

00:32:03ok

00:32:04ok

00:32:05this

00:32:06this

00:32:07to be

00:32:08who

00:32:09are

00:32:10now

00:32:11some

00:32:12people

00:32:13they

00:32:15have

00:32:16and

00:32:17these

00:32:18are

00:32:19and

00:32:20now

00:32:21they

00:32:22have

00:32:23some

00:32:24other

00:32:25all

00:32:26Delete the records from department table that do not have matching records in EMP.

00:32:56Delete the records from department table.

00:33:09Delete the records from department table, which is not in EMP.

00:33:21If you come here, you can see that the department is 10, 20, 30, but the 40 department is not in the 40 department.

00:33:38So we will delete the records from this record.

00:33:45Yes, let me tell you.

00:33:471, 2, 3, 2, 3, how is it?

00:33:53This is a little bit.

00:33:57Select the records.

00:34:01Do you want to delete the records?

00:34:06If you want to delete the records, let me tell you.

00:34:10First, let's delete the records.

00:34:13Select start.

00:34:16Start and then dptn.

00:34:20D.dptn.

00:34:24D.dptn.

00:34:26What's up here?

00:34:27What happened?

00:34:28D.dptn.

00:34:29Ok masi.

00:34:31Yes.

00:34:32D.dptn.

00:34:33Yes.

00:34:34For the record, you don't repeat any.

00:34:36Sir, from department.

00:34:37Sir, from department.

00:34:39This department came to server.

00:34:40What have you done?

00:34:42What do you do?

00:34:44What do you do?

00:34:46Yes.

00:34:47What are you doing?

00:34:48What are you doing?

00:34:53What is going to do?

00:34:55foreign department deputy deputy or you know

00:35:02yes you know you have a deputy caro yeah imply caro is a picoat me

00:35:07left join

00:35:15sir emp

00:35:20or e here on

00:35:25sir afer e dot dpt no

00:35:29equal to d dot dpt no

00:35:44oh

00:35:46find what are you doing

00:35:52sir where

00:36:06where

00:36:06I will put a file in the file.

00:36:07E.dpt.

00:36:08No.

00:36:09Equal to null.

00:36:13Equal to null.

00:36:18Is null.

00:36:20Is null.

00:36:21Oh.

00:36:23Now, where we have selected, we have delete.

00:36:35I

00:36:39I

00:36:41I

00:36:43I

00:36:45Sir, just here I am daling in, so delete, table name I am daling in, sir.

00:37:14Delete, from, dpt.

00:37:17D, dpt.

00:37:30D, dpt.

00:37:35D, dpt.

00:37:37Right.

00:37:39Sir, tell me about it.

00:37:48It's bad.

00:37:49Let's go.

00:37:51Let's see.

00:37:52If we do not need to delete from, I will tell you.

00:37:57DEPT where DEPT is equal to 30.

00:38:05If I do this, then what will happen?

00:38:10Sir, DEPT 30 will delete from the department table.

00:38:16DEPT 30 will be removed.

00:38:19Who will remove it?

00:38:22We can see it.

00:38:25But when the numbers are less, we will not be able to remove it.

00:38:30Yes, sir.

00:38:31First, we need to remove it.

00:38:34How do we remove it?

00:38:36Sir, there is one, which is not matching.

00:38:42What is not matching?

00:38:46Yes, the not matching, which is not matching.

00:38:47Yes, the two tables will not match.

00:38:52We will filter the data.

00:38:54Which one says, sir?

00:38:55No, no.

00:38:56If you do not match, then you will need to make a condition.

00:38:59Look, inner, outer, left, right, full, cross, self.

00:39:14That's what we need to do.

00:39:17The note is null.

00:39:18The note is null.

00:39:19Will you remove 40 from here?

00:39:22Yes.

00:39:23We remove 40 from here.

00:39:24Look.

00:39:25It is the same.

00:39:27Now, what do we do?

00:39:29Let us remove both from here.

00:39:32What do we do?

00:39:33What is the question?

00:39:35What is the question?

00:39:37Delete the record from the deployer who do not have matching for the deployer.

00:39:42In the department, in the DEPT table, there is no implies.

00:39:48Select DEPT-NO from EMP.

00:39:54This is done.

00:39:56This is done.

00:39:58This is done.

00:40:00Is it done?

00:40:03This is done.

00:40:06Now I will write.

00:40:08Select DEPT-NO from DEPT-NO from DEPT-NO from DEPT-NO.

00:40:23Not in.

00:40:24Not in.

00:40:33Is it 40?

00:40:34Yes.

00:40:3540, which is not in.

00:40:39Who is it?

00:40:40Sir, it is employable.

00:40:44It is employable.

00:40:46It is employable.

00:40:48So, now I will write here.

00:40:51Delete from department where DEPT-NO is equal to.

00:41:03Copy this.

00:41:06If I will put it here, then who will turn it?

00:41:10It will delete it.

00:41:13Okay.

00:41:14Yes.

00:41:15Yes.

00:41:17So, you can see here.

00:41:18Where is the directory of this directory?

00:41:20Is it a location?

00:41:21Yes.

00:41:22OK.

00:41:23It will be.

00:41:24So, here we are.

00:41:25I will see if our directory is unknown.

00:41:27There is an location under a fire that is unknown.

00:41:30Okay.

00:41:31Let's see.

00:41:32Alright.

00:41:33Let's see.

00:41:34Let's see which area is unknown.

00:41:35Next.

00:41:36Okay.

00:41:37There is two neighboring people in the direction.

00:41:40Next.

00:41:41yes sir

00:41:44The last question is coming from the last one

00:41:4839

00:41:50Sound is on the side of the screen

00:41:57The computer is closed

00:42:00The computer is closed

00:42:02The computer is closed

00:42:07The confusion is so much

00:42:09The computer is closed

00:42:12The computer is closed

00:42:15The computer is closed

00:42:30The computer has a laptop

00:42:35The computer has no time

00:42:37I'm 39

00:42:39I

00:42:41I

00:42:43I

00:42:45I

00:42:47I

00:42:53I

00:42:55I

00:42:57I

00:42:59I

00:43:01I

00:43:03I

00:43:05I

00:43:07I

00:43:09I

00:43:11I

00:43:13I

00:43:15I

00:43:17I

00:43:19I

00:43:21I

00:43:23I

00:43:25I

00:43:27I

00:43:29I

00:43:31I

00:43:33I

00:43:35I

00:43:37I

00:43:39I

00:43:41I

00:43:43I

00:43:45I

00:43:47I

00:43:49I

00:43:55I

00:43:57I

00:44:01I

00:44:03I

00:44:05I

00:44:07I

00:44:09I

00:44:11I

00:44:13I

00:44:15I

00:44:17I

00:44:19I

00:44:21I

00:44:23I

00:44:25I

00:44:27I

00:44:29I

00:44:31I

00:44:33I

00:44:35I

00:44:37I

00:44:39I

00:44:41I

00:44:43I

00:44:45I

00:44:47I

00:44:49I

00:44:51I

00:44:53I

00:44:55I

00:44:57I

00:44:59I

00:45:01I

00:45:03I

00:45:05I

00:45:07I

00:45:09I

00:45:11I

00:45:13I

00:45:15I

00:45:17I

00:45:19I

00:45:21I

00:45:23I

00:45:25I

00:45:27I

00:45:29I

00:45:31I

00:45:33I

00:45:35I

00:45:37I

00:45:39I

00:45:41I

00:45:43I

00:45:45I

00:45:47I

00:45:49I

00:45:51I

00:45:53I

00:45:55I

00:45:57I

00:45:59I

00:46:01I

00:46:03I

00:46:05I

00:46:07I

00:46:09I

00:46:11I

00:46:13I

00:46:15I

00:46:17I

00:46:19I

00:46:21I

00:46:23I

00:46:25I

00:46:27I

00:46:29I

00:46:31I

00:46:33I

00:46:35I

00:46:37I

00:46:39I

00:46:41I

00:46:43I

00:46:45I

00:46:47I

00:46:49I

00:46:51I

00:46:53I

00:46:55I

00:46:57I

00:46:59I

00:47:01I

00:47:03I

00:47:05I

00:47:07I

00:47:09I

00:47:11I

00:47:13I

00:47:15I

00:47:17I

00:47:19I

00:47:21I

00:47:23I

00:47:25I

00:47:27I

00:47:29I

00:47:31I

00:47:33I

00:47:35I

00:47:37I

00:47:39I

00:47:41I

00:47:43I

00:47:45I

00:47:47I

00:47:49है ठीक है कि यहां पे फ़ोटी होगा है

00:47:56दस में है अकॉंटिंग

00:48:02हुआ है हुआ है है क्या कि अपिस्ण थोड़ा वहत गरबर हो सकता है

00:48:11है बीस में है रिसर्च

00:48:19In the 30th, Cells, in the 40th, Operations.

00:48:39I am understanding something like this.

00:48:43I also understand this question.

00:48:46I have to understand this question.

00:48:49That we need to do this type of output.

00:48:53Because it has a null.

00:48:57It has a null.

00:48:59It has a null.

00:49:01Why?

00:49:02Because it doesn't have a null.

00:49:04Let me tell you how it will happen.

00:49:07Select.

00:49:08E.ename.

00:49:09E.ename.

00:49:10E.ename.

00:49:11E.ename.

00:49:12E.ename.

00:49:13E.ename.

00:49:15E.ename.

00:49:16E.ename.

00:49:17E.ename.

00:49:18E.ename.

00:49:19E.ename.

00:49:20E.ename.

00:49:21E.ename.

00:49:22E.ename.

00:49:23E.ename.

00:49:24E.ename.

00:49:25E.ename.

00:49:26E.ename.

00:49:27E.ename.

00:49:30E.ename.

00:49:31E.ename.

00:49:32E.ename.

00:49:34From

00:49:40Sir, I'll call it from

00:49:42From

00:49:44From

00:49:46D.

00:49:54Department number

00:49:56Department name

00:49:58Department name

00:50:04Department name

00:50:06department name

00:50:10Department name

00:50:12Department name

00:50:14D name

00:50:16D name

00:50:18D name

00:50:20Sir

00:50:22From

00:50:24D

00:50:26D

00:50:28D

00:50:30D

00:50:32D

00:50:34I said left to join

00:50:36us give us our e EMP

00:50:44sorry MP is a video

00:50:52you are on

00:50:57dp.dpt

00:51:02dp.dpt

00:51:14dpt

00:51:26dpt

00:51:28dpt

00:51:34dpt

00:51:36dpt

00:51:38dpt

00:51:40dpt

00:51:42dpt

00:51:52edp

00:51:54dpt

00:51:56dpt

00:51:59dpt

00:52:09dpt

00:52:11Is someone in the condition of the condition?

00:52:15Why?

00:52:17Let's go.

00:52:19E.

00:52:21E.

00:52:23E.

00:52:24E.

00:52:25E.

00:52:26E.

00:52:28E.

00:52:30E.

00:52:31E.

00:52:32E.

00:52:34E.

00:52:35E.

00:52:36E.

00:52:37E.

00:52:38E.

00:52:39�zw.

00:52:45�r

00:52:48�

00:52:49�

00:52:50�

00:52:52P

00:53:05�

00:53:08is left join job

00:53:09Kuroko left side

00:53:10says

00:53:10I will go to the

00:53:11there will be a

00:53:12not

00:53:14by this

00:53:15go

00:53:15to the

00:53:15outer

00:53:16join

00:53:16is

00:53:19a

00:53:20a

00:53:22a

00:53:23a

00:53:24a

00:53:26a

00:53:27a

00:53:28a

00:53:29a

00:53:30a

00:53:31a

00:53:32a

00:53:33a

00:53:34a

00:53:35a

00:53:37a

00:53:38I don't want to use the dptn to add to Dptn.

00:53:45If it doesn't work as dptn to our job, then in this

00:54:03where e dot dpt no is not null

00:54:16if I do this then the problem will be broken

00:54:20this is broken

00:54:23hahaha

00:54:28how will it happen?

00:54:33no one knows

00:54:35department

00:54:37dpt

00:54:40dname

00:54:44Yeah

00:54:47I say

00:54:49ah

00:54:51Yeah

00:54:52Yeah

00:54:53Yeah

00:54:54Yeah

00:54:56What the

00:54:57Okay

00:54:58Now

00:55:03Yeah, if e.ename is null, then you will come to this place.

00:55:11The whole field will not come to everyone.

00:55:16If you can use it, sir.

00:55:20If you can use it, but there will not be everything here.

00:55:26If I use one name, e.ename, I use it.

00:55:35Is it null?

00:55:38And here I use it, is null.

00:55:44And here I use it, no.

00:55:54We can see it.

00:55:57Yes, it's a single pole.

00:56:01Yes, it's a single pole.

00:56:09It's gone.

00:56:11It's gone.

00:56:13It's gone.

00:56:15If we can remove it, then we can remove it.

00:56:22Let's do it.

00:56:24Let's do it.

00:56:26It's gone.

00:56:27It's not going to be done.

00:56:29Here it is D.

00:56:31D.

00:56:33D.

00:56:35D.

00:56:37D.

00:56:39It will be a stripe.

00:56:41D.

00:56:43D.

00:56:45D.

00:56:47It will come.

00:56:49It will come.

00:56:51It will come.

00:56:53It will come.

00:56:55It will come.

00:56:57It will come.

00:56:59It will come.

00:57:01It will come.

00:57:03It will come.

00:57:05It will come.

00:57:09Question number 40.

00:57:11D.

00:57:13D.

00:57:15Sunday.

00:57:17Sunday.

00:57:19Get all the matching and not matching records from the tables.

00:57:29Getting the matching and non matching records from the table.

00:57:33It will come.

00:57:35What does it mean?

00:57:37The two.

00:57:39The two.

00:57:41The two.

00:57:43The two.

00:57:45The two.

00:57:47The two.

00:57:49The two.

00:57:51The two.

00:57:53The two.

00:57:55The two.

00:57:57The two.

00:58:11The two.

00:58:13The two.

00:58:15The two.

Category

Transcript

Recommended