- 2 days ago
Hi, this video will help you to SQL interview preparation.
Whatsapp Group Link- https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
SQL Script file : -https://drive.google.com/file/d/1ceBSo7DjQgGMPbq7hJ2En2YdNGmoM2H5/view?usp=sharing
Whatsapp Group Link- https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
SQL Script file : -https://drive.google.com/file/d/1ceBSo7DjQgGMPbq7hJ2En2YdNGmoM2H5/view?usp=sharing
Category
📚
LearningTranscript
00:00I am searching for which video was.
00:02Let's go.
00:04Question is this.
00:08It was an image.
00:12Where did the image go?
00:14This is.
00:16This is.
00:20This is.
00:22The output is this way.
00:26Create database.
00:32July 20.
00:3820.
00:40Use.
00:42Use.
00:48This is done.
00:50Take care.
00:56Here you can.
00:58I have put it in the table.
01:00I have put it in the table.
01:02Insert the record.
01:04I will put it in the table.
01:06Like this.
01:08I will put it in the table.
01:10Okay?
01:12Here you can.
01:14There is a day.
01:16There is a sales person.
01:18There is a sales person.
01:20It is a sales amount.
01:22Output is a status.
01:24I need date wise per person maximum amount.
01:31Date wise per person maximum.
01:36How do you think it's simple?
01:38It's simple.
01:40Data is like this.
01:43I mean, if I see one thing.
01:48Where sales person is equal to A.
01:55So, here is how many records will come?
01:59300 will come?
02:01No.
02:021 will come.
02:031 will come.
02:041 will come.
02:051 will come.
02:061 will come.
02:072 will come.
02:09If I add B.
02:11So, B is 320.
02:15In that it was.
02:18The C is 350.
02:20After I checked on the C was at all.
02:27350 maximum.
02:28There are more records of entry.
02:32Let's go.
02:33No one need.
02:34Okay.
02:35Okay.
02:36Do you understand the question?
02:38Sir, the question is that...
02:40So if there are two cells, then one will go to the next person.
02:53The question is that the desired output coming from each person.
02:59The maximum is 300 cells.
03:02If there is a date of 3 or 4, then take one date.
03:07Okay, tell me.
03:12Select the salesperson.
03:18Who is the salesperson?
03:27What was that?
03:29The data table.
03:33The salesperson, what is that?
03:37The max is the sales amount.
03:45The group is the salesperson.
03:53The list looks smooth.
03:55The reference is the same as the font size.
03:58The token is the same as the entire.
04:00But this is the same as the values.
04:02The following is the same as the salesperson.
04:05The second is the same as the amount.
04:07If the payment is the same, it will have a result.
04:10The other is the same as the amount.
04:13The next is the same as the husband.
04:16As a sales amount, I will add it to the sales amount.
04:20Yes, I will add it to the maximum amount.
04:23Max amount.
04:28Okay sir, I will add one more.
04:31I will add one more.
04:33I will add one more.
04:34I will add it to the sales amount.
04:36Select.
04:39Where is it?
04:40Join.
04:41I will add it to the sales amount.
04:43I will add it to the sales amount.
04:45I will add it to the sales amount.
04:48Select.
04:49Go down, go down here.
04:51Join, go down here.
04:55Data table, add a little abbreviation.
05:04Add an add con.
05:06jaet.
05:07D select algo.
05:09And then, lique.
05:13I am not sure how to do this.
05:20And what is it?
05:23Sir, the sales person can do this.
05:30Let me take this.
05:33Now I have written it.
05:36Where is it?
05:39Where did you write?
05:42Select?
05:43Select?
05:44I am sure select.
05:54Date?
05:55D.date?
06:05Who is this name?
06:09So most of the time I was that I got a very close Aristide.
06:21Amen.
06:25Yes, yes.
06:29Yes, yes.
06:31Yes, yes.
06:37What's the reason is...
06:41Yes, I have no idea.
06:44Yes, yes.
06:48So, let's get the D.
06:51Which D?
06:53Let's get the D.
06:55Let's get the D.
07:01Let's get the D.
07:03Let's get the D.
07:18Let's get the D.
07:20Let's get the D.
07:21Now, let's get the D.
07:22Which city else?
07:23Let's get the D.
07:29Like this?
07:31Yeah.
07:36City.
07:39Is this going to happen, sir?
07:41Yeah.
07:44Yeah.
07:45Yeah.
07:46Yeah.
07:47How did it happen?
07:51Why did it stop?
07:55Let's get the D.
07:56Let's get the D.
07:57Let's get the D.
08:02Now, let's get the D.
08:03Yeah.
08:04Now, this is our table.
08:06We'll put the D.
08:11Join.
08:13Yeah, sir.
08:14And now, let's get the data table.
08:16Data table.
08:18Yeah.
08:19On.
08:22On.
08:23On.
08:24Yeah.
08:25In this case, we have a match.
08:27Now, we have a match.
08:28The city.
08:31Sales person.
08:33Data table.
08:34Data table.
08:35Sales amount, sir.
08:36Huh?
08:37Right, Right.
08:38Data table,
08:40Right.
08:41Data table.
08:42Sales amount, sir.
08:44Data table.
08:45Sales amount, sir.
08:46Hmm?
08:47Right, right.
08:48Data table.
08:49Data table.
08:50Dot.
08:51Sales amount.
08:52And now,
08:53import.
08:54Comma.
08:55Comma?
08:56It's our annual label.
08:57Now, we have an awful lot.
08:58Appalach.
08:59Yes, that's our display,
09:00the location.
09:01I will give you a comma.
09:04Yes, sir, comma, give me a comma.
09:06I will give you a comma, and percent, and percent.
09:09And or city dot
09:14your salesperson
09:19equal to
09:23table.salesperson
09:28and sir, you can add a date in that.
09:32We have taken a star
09:34in the select star.
09:36Yes.
09:38Put here, sir.
09:40Data table, date.
09:42And
09:44comma
09:46Yes, yes.
09:48And
09:50star, sir, just add a star.
09:56And
09:58I will repeat it.
10:00Now
10:02Don't take the star, sir.
10:04That will come again.
10:06Something's changed.
10:08Distinct, sir.
10:10Give me a distinct, sir.
10:12Give me a distinct, sir.
10:20Wow, it's coming.
10:22No, no, no.
10:24No, no.
10:26No, no, no, no, no.
10:28301, 304, 2320.
10:33Yeah, it's done.
10:33It's done.
10:35It's done.
10:36It's gone.
10:37It's gone.
10:38It's gone.
10:40It's gone.
10:40Second one is gender by sorting.
10:44Check image.
10:46We've seen this in past.
10:50What is this?
10:52I'll create a table.
10:54Table 123.
10:55I have inserted the data in this area and this is the result of the data.
11:13The need to sort data one male and one female should be appear.
11:23One male, one female, one male, one female.
11:30Do you understand why?
11:35I understand.
11:39How is this going to fall?
11:45How is this going to fall?
11:52How is this going to fall?
11:59If you have a row count, then you will short the row.
12:05How is this going to fall?
12:07Select star, star, row number.
12:22Yes sir.
12:25Over, order by.
12:29Partition by is gender.
12:35Order by is gender.
12:37Do you want to fall?
12:38No.
12:39No.
12:40No.
12:41No.
12:42No.
12:43No.
12:44No.
12:45No.
12:46No.
12:47No.
12:48No.
12:49No.
12:50No.
12:51There you go.
12:52No.
12:53Yes sir.
12:54What are you already relation to?
12:55Oh well.
12:56Oh I właśnie state.
12:57Yeah I am место.
12:58Oh yes correct.
12:59Oh.
13:00Here you go.
13:01data one two three.
13:02Yeah, this is now like.
13:04Now, let me show you the order by
13:12RNM-BR
13:13RNM-BR
13:15BUS
13:16BUS
13:17BUS
13:18BUS
13:19BUS
13:20BUS
13:21BUS
13:22BUS
13:23BUS
13:24BUS
13:25BUS
13:26BUS
13:27BUS
13:28BUS
13:29BUS
13:30BUS
13:31BUS
13:32BUS
13:33BUS
13:34BUS
13:35BUS
13:36BUS
13:37BUS
13:38BUS
13:39BUS
13:40BUS
13:41BUS
13:42BUS
13:43BUS
13:44BUS
13:45BUS
13:46BUS
13:47BUS
13:48BUS
13:49BUS
13:50BUS
13:51BUS
13:52BUS
13:54BUS
13:55BUS
13:56BUS
13:57BUS
13:58BUS
13:59BUS
14:00BUS
14:01BUS
14:02you
14:04know
14:06you
14:08know
14:10you
14:12I don't know.
14:14It's not the answer.
14:16It's not the answer.
14:18I don't know.
14:20So,
14:21here we go,
14:23order by
14:24gender,
14:26e.
14:27I don't know.
14:29I don't know.
14:31I don't know.
14:33I don't know.
14:35I don't know.
14:37I don't know.
14:39I don't know.
14:44Remember when I came,
14:46oh,
15:01oh,
15:02yeah.
15:04Sanjeev, I told you about AGM that there is a class joining in 7X.
15:10Yes, sir, I told you.
15:13I told him that you have to join the class, but you will have to practice more and better.
15:21Sir, tell me, I will show you the recording, so I will share it.
15:25I will show you the recording, so I will show you the recording.
15:34I will show you the recording.
15:38I will get something extra.
15:42This is not our work.
15:45I will show you the recording.
15:50Okay, sir, female is 3.
15:51This is the recording.
15:53This will be the recording.
15:55I will show you the recording.
16:00Okay, I understand.
16:021, 4.
16:04I will show you the recording.
16:19I will show you the recording.
16:24I will show you the recording.
16:30I will add partition by, you don't have to put it in general.
16:44Everything is okay, if I will add this to DESC, it's done.
16:56It's done.
16:58There's a little question.
17:00It's not.
17:02It's not.
17:04It's not.
17:06It's a little bit.
17:10We create data.
17:12Select the star around data.
17:16Need output as for image.
17:26A performance.
17:281,2,3,4,5,5,6,6,6,7,7,7,1,2,3,4,5,6,7,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,9,8,8,9,1,2,3,4,5,6,7,7,9,1,2,3,4,5,6.
17:43This image art.
17:48Look, I need output.
18:02One, two, one, two, two, three, three, four.
18:08What does logic mean?
18:10I can't understand the logic.
18:13I can't understand the logic.
18:15I can't understand the logic.
18:17Good.
18:18Partition, what does the number mean?
18:21I'm saying that the number is just like this.
18:26But it will also become a count.
18:32It will not become a count.
18:34How does it become a count?
18:36No, no.
18:37It's a ranking.
18:39Yes, it's a ranking.
18:41Yes, it's a ranking.
18:42It's a ranking.
18:43It's a ranking.
18:44It's a ranking.
18:45Do you use a dance rank?
18:47Dance rank.
18:48Dance rank.
18:49Dance rank.
18:50Dance rank.
18:57Without dance rank, it won't be?
19:01You have to see the output.
19:03Okay, if you do rank, then tell me.
19:07Select.
19:08Select.
19:09Select.
19:10Select.
19:11Select.
19:12Start.
19:13Dance rank.
19:14No, it's a rank.
19:16Select.
19:18Select.
19:19Start.
19:20Dance rank.
19:21No, it's a rank.
19:22Dance rank.
19:23Over.
19:24Order by amount.
19:25no dense rank over order by amount
19:38and look you will change
19:43edge
19:48come on
20:00order by
20:03Yes, I am not sure that we have not been able to sort it.
20:11Yes, that's correct.
20:15We have not been able to sort it.
20:19If you haven't been able to sort it, then what will you do?
20:25So this number comes from side, what do you call it?
20:31Which number?
20:32Index number
20:33This
20:34No, sir
20:35No, no, sir
20:361, 2, 3, 4, 5, 6
20:381, 2
20:401, 2
20:421, 2
20:431, 2
20:441, 2
20:451, 2
20:461, 2
20:471, 2
20:481, 2
20:491, 2
20:501, 2
20:511, 2
20:521, 2
20:531, 2
20:541, 2
20:551, 2
20:571, 2
20:581, 2
20:591, 2
21:002
21:012
21:021, 2
21:031, 2
21:051, 2
21:061
21:071, 2
21:082
21:092
21:102
21:113
21:122
21:133
21:141
21:151
21:172
21:181
21:191
21:202
21:211
21:222
21:23I can see the order order by me I am
21:30I am
21:32I am
21:34I am
21:35I am
21:40I am
21:43I am
21:44I am
21:45I am
21:46I am
21:48I am
21:51oh no no no no no no no no no no no no no no CARA
22:03oh
22:08oh sorry
22:15oh no no no no
22:21I will do this again.
22:32I will do this again.
22:34I will do this again.
22:40But it's like our image.
22:42The image is like this.
22:44It means that
22:46This sequence is not changed, right?
22:51Yes sir.
22:53This sequence is not changed.
22:56Why can't we join here?
22:59Join will be added to our class.
23:02I think.
23:07If you use the order by, sir, you will short.
23:11Order by, sir, amount.
23:16Bracket 1.
23:19This is not changed, sir.
23:23It's not changed, sir.
23:25No.
23:26You didn't change the amount?
23:29The amount, sir, was also short.
23:32It was also short.
23:34It was also short.
23:36It was also short.
23:38It was not done with our work.
23:41Do it with this, sir.
23:44I'm telling you.
23:45Give me a dance rank.
23:47Give me a dance rank.
23:49Give me a dance rank.
23:50Give me a row number first.
23:53Yes.
23:54Yes.
23:55Yes.
23:56Yes.
23:57Yes.
23:58Yes.
23:59Yes.
24:00Yes.
24:01Yes.
24:02Yes.
24:03Yes.
24:04Yes.
24:22So how do we bring the same series, without order?
24:27We can do the same series.
24:29We can do the same series.
24:31Let's leave the first data.
24:33Let's leave it here.
24:35Let's see.
24:37Let's see.
24:38Let's see.
24:39Let's see.
24:40Let's see.
24:42Let's do this.
24:43Let's use it.
24:45With CTE as
24:50select a star from CTE.
24:56Is it?
24:58Is it?
25:00Let's do this.
25:02Let's do this.
25:04Let's do this.
25:06Let's do this.
25:08Let's do this.
25:10Let's do this.
25:12Data1 amount.
25:14Let's do this.
25:16As it is.
25:18or
25:20left to join data1
25:24on
25:26data1
25:28amt
25:30is equal to
25:32CTE
25:34dot amt.
25:36how
25:37amt
25:38I
25:39do
25:40I
25:42I
25:44do
25:45I
25:46do
25:47I
25:48I
25:50do
25:51the
25:52This is the logic that I can understand.
25:54Sir, this is the logic that I can understand.
25:57I am doing this.
25:59I am doing this.
26:01My data is this.
26:03Select a copy with the header.
26:15Is it like this?
26:17It's okay.
26:22I have removed this.
26:27Is it clear here?
26:30It's our second table.
26:33Yes, sir.
26:34I am doing it.
26:35If I can do this,
26:37will it come?
26:43It's true, sir.
26:45But it doesn't look like this.
26:47You don't look like this.
26:50First, you have to take the wallet table.
26:52Select data 1.
26:55Then you have to take the city.
26:57So, this is...
26:58Yes, sir.
26:59Yes, sir.
27:00In data 1, please join.
27:02I am going to stay here.
27:04Yes, sir.
27:05Please leave it like this.
27:07Yes, please leave it like this.
27:08Now, please select where it is written.
27:10Join above.
27:12And above.
27:14I am going to stay here.
27:16Okay.
27:17Let's leave this.
27:18Yes, sir.
27:19We will...
27:20Select...
27:21Star...
27:22Data 1...
27:23Data...
27:24And...
27:25Change.
27:26Now...
27:27You will see the star...
27:28Data 1...
27:29Data 1...
27:30Now...
27:31I will see the star...
27:32Data 1 amount...
27:33Data 1.amount...
27:34Data 1.amount...
27:35amount
27:37okay
27:39ct
27:41dot
27:43your
27:45dance rnq
27:47yes
27:49and then
27:51enter
27:53okay
27:55and join
27:59and this is all your
28:01join
28:03okay
28:05okay
28:07second table
28:09we will do this
28:11and
28:13where is the bracket
28:15where is the bracket
28:17we will do
28:19two brackets
28:21okay
28:23as
28:25tt
28:27on
28:29dot
28:31amt
28:33equal to
28:35tt dot
28:37amt
28:39you
28:41don't
28:43do
28:45do
28:47do
28:49do
28:51do
28:53do
28:55do
28:57do
28:59do
29:01do
29:03do
29:05do
29:07do
29:09do
29:11do
29:13do
29:15do
29:19do
29:21do
29:23do
29:25do
29:27do
29:29do
29:31do
29:33do
29:35do
29:37do
29:39do
29:41do
29:43do
29:45do
29:47do
29:49do
29:51do
29:53do
29:55do
29:57do
29:59do
30:01do
30:03do
30:05do
30:07do
30:09do
30:11do
30:13do
30:15do
30:17do
30:19do
30:21do
30:23do
30:25do
30:27do
30:29do
30:31do
30:43do
30:45do
30:47do
30:49do
30:51do
30:53do
30:55do
30:57do
30:59do
31:01do
31:03do
31:05do
31:07do
31:09do
31:11do
31:13do
31:15do
31:17do
31:19do
31:21do
31:23do
31:25do
31:27do
31:29do
31:31do
31:33do
31:35do
31:37do
31:39do
31:41do
31:47do
31:49do
31:51do
31:55do
31:57do
32:01do
32:03do
32:05do
32:07This is our case.
32:12Here is no problem.
32:16But here is no problem.
32:27If I write here, select CTE.
32:34Select star from data1, select star from city, select data1.amt
32:58Select star, select star1.amt
33:20I am not going to go to the airport.
33:27I am not going to go to the airport.
33:32I am not going to go to the airport.
33:37How is the airport?
33:40Are you still in the airport?
33:45Is it in our format?
33:47Yes, it is in our format.
33:49We are one of our city.
33:51Yes.
34:15Yes, it is in our format.
34:17Please, we are going to examine.
34:23We are going to find our original game.
34:25Oh, my God.
34:27We are three and I will find out.
34:41Yes, correct.
34:434333, 1131, 432, 432, 543, 540.
35:10Oh God.
35:13It's been closed, but it's been taken a little.
35:20What is this?
35:23Tell me about this too.
35:26Oh.
35:29I will leave the interview.
35:33I don't know if it's an experienced person in the forest.
35:40This is a table.
35:43Table T1.
35:46Table name and number.
35:50T number.
35:56I don't know all of this.
36:02We're gonna spit,ね, right, one end.
36:08thanked me.
36:12We're gonna Hussey with the door.
36:16In the original version, I worked with the game, for everything I put in this score and
36:23put in one person.
36:24With the original version of the game, I do not have to use the game and then replace on
36:40the entire version of the game.
36:45I have to copy it and paste it in a new sheet.
36:53I am telling you, I have to select it.
36:57How is it?
36:59Ctrl-H
37:01Ctrl-H
37:03This number is X-X.
37:05Here you can see that one and all.
37:11Clear?
37:13Here you go, sir.
37:19Okay.
37:20Now we have our number.
37:23This is saying that the two numbers are positive and negative.
37:29Do you understand?
37:43Yes, sir.
37:45Now we have data.
37:47This is your data.
37:57Now tell us.
37:59We will stop.
38:01Sir, click here select.
38:17Sir, amount.
38:19Amount
38:21Amt
38:23Amt
38:25greater than 0
38:29As a positive
38:37Positives?
38:39POS
38:41Thoma
38:43Same way, amount less than zero
38:47As a negative
38:51As a negative
38:55From
38:57Like
38:59Like
39:01Where
39:032
39:05Select
39:07Amount
39:09Amt
39:11From
39:15T Number
39:23T Number
39:25From
39:33Where
39:35Amount
39:39Greater
39:41Than
39:43Zero
39:45As a
39:47As a
39:49As a
39:51As a
39:53As a
39:55As a
39:57Amt
39:59Amt
40:01Amt
40:07Pam
40:11Is
40:12Do
40:13Do
40:15As
40:17As
40:18As
40:19As
40:20As
40:21As
40:23As
40:25As
40:27As
40:29So, let's make this logic in this way.
40:36Minus 500, minus 200, minus 600.
40:40This one, two, three.
40:44300, 150, 400.
40:48This one, two, three.
40:51If you remove this data,
40:53you will open a path?
40:55Yes.
40:56It's a problem.
40:59The columns are different.
41:02You will create a different column?
41:05No, I'll leave it.
41:08No, I'll leave it.
41:10No, I'll leave it.
41:14Then, how will it happen?
41:17No, I'll leave it.
41:19I'll leave it.
41:21I'll leave it.
41:23I'll leave it.
41:25Do it.
41:27I'll leave it.
41:29I'll leave it.
41:31With CTE,
41:32select,
41:35star from,
41:38T number,
41:40where
41:42AMT
41:44less than 0.
41:46negative number.
41:47So,
41:48select,
41:49star from,
41:50CTE.
41:51Again,
41:53I'll leave it.
41:55Here,
41:56I'll leave it.
41:57I'll leave it.
41:58Row number
42:01over
42:03order by
42:08AMT
42:09as
42:11less than
42:13negative number.
42:15Okay?
42:16Where
42:17are you?
42:18Where
42:20are you?
42:21Where are you?
42:22going?
42:23Where
42:24are you?
42:25Where
42:26are you?
42:27Oh,
42:28oh, oh, oh, oh, oh.
42:29city
42:32is cooperating here.
42:34I've come from here.
42:35I've come from here.
42:37I've come from here.
42:39I've come from here.
42:40I've come from here.
42:41Now I'll leave it.
42:43Now I will put a comma with CT to add it.
42:58Greater than zero.
43:02Positive number.
43:08I will put a comma with CT to add it.
43:15How did this happen?
43:23I want to work on CT to do this.
43:27I will put a comma here.
43:31I will put a comma here.
43:38I will put a comma here.
43:41Now I will put a comma here.
43:45I will put a comma here.
43:48Post number is equal to.
43:51I will put a comma here.
43:58Select.
44:00I will put a comma here.
44:03I will put a comma here.
44:06I will put a comma here.
44:10Select.
44:14What?
44:15This is AMT to Eage.
44:21Oh!
44:22CT met amt
44:24from
44:25As a
44:29Your first question is negative.
44:31DM!
44:33Cte
44:34했
44:36Negative
44:38From
44:40CT
44:44join cte2 on cte1.negative number
45:11neg underscore number equal to cte2.cos underscore number
45:26underscore number
45:28more?
45:30yes sir, negative to positive
45:34this one, okay sorry sorry sorry sorry
45:37here
45:39no
45:41cte2
45:42cte2.mth
45:46cte2.mth
45:48cte2.mth
45:51cte2.mth
45:54cte2.mth
45:56cte2.mth
45:59cte2.mth
46:01It's gone Sanjeev
46:05We have practice of CT and the role, rank, and the role, rank, etc.
46:15Yes, it's gone
46:17It's gone
46:19It's gone
46:21It's gone
46:23If it's done
46:25If it's done
46:27It's gone
46:29It's gone
46:37This is CT
46:39It's gone
46:41It's solved
46:43Let's close it today
46:45Okay
46:47Okay
46:49X
46:51You
46:53You
46:55You
46:57You
46:59You
47:01You
47:03You
47:05You
Recommended
1:17:44
|
Up next
1:30:13
1:27:55
1:31:40
1:35
1:43
4:00
1:08:26
1:08:17
1:44:20
19:03
1:03:00
1:31:31
1:11:49
1:08:19
1:58:00
1:10:48
1:20:45
21:29