- 4 months 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/1Lv1K1WhecUnr91eth9yVCK8MP1pezSwE/view?usp=sharing
Whatsapp Group Link- https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
SQL Script file : -https://drive.google.com/file/d/1Lv1K1WhecUnr91eth9yVCK8MP1pezSwE/view?usp=sharing
Category
📚
LearningTranscript
00:00:00Is it one or two?
00:00:03Let's see one small question.
00:00:07We are watching a lot of times.
00:00:11So, we will create a table today.
00:00:17Create database.
00:00:19All of us will be remembered.
00:00:22Yes?
00:00:23Yes.
00:00:30What do we do?
00:00:35The user will tell us about the database.
00:00:40We will know how to work.
00:00:42Use means that we are telling us about the database.
00:00:47So, I have created a table.
00:00:50Impli.
00:00:52We have added a record.
00:00:57Here is a table.
00:01:00Department.
00:01:02We have recorded.
00:01:07We have two tables.
00:01:10Select star.
00:01:12Impli.
00:01:16I have created a table.
00:01:19I have chosen a table.
00:01:21I have chosen a table.
00:01:24Right?
00:01:25I have chosen a table.
00:01:26Select a table.
00:01:27Select star.
00:01:28enter a table.
00:01:29If I find a table.
00:01:31I will put it.
00:01:32I will put it.
00:01:33Ok?
00:01:34It is possible.
00:01:35It is possible.
00:01:36We have a lot of questions.
00:01:37Repeat itself.
00:01:39Okay?
00:01:40display the name of employees who are working in sales department
00:01:55I think we have worked on the sales department
00:02:11how to do it
00:02:15It's simple. Select.
00:02:17I'm saying it's simple, Sanjeev.
00:02:21I think we've also done a lot of work.
00:02:27Select.
00:02:31I'm saying display name.
00:02:35Name.
00:02:37From.
00:02:41Ename.
00:02:45Ename from.
00:02:47PMP.
00:02:51Where.
00:02:53Aapka DPTL no?
00:02:57Department number.
00:02:59Equal to 30.
00:03:03But this is not the right way.
00:03:07I have to fix it.
00:03:09I have to fix it.
00:03:11Why is it happening here?
00:03:13D2TL no?
00:03:15Why is it happening here?
00:03:17D2TL no?
00:03:19It's coming.
00:03:21If you want to show it with a joint,
00:03:23Why do you want to show it with a joint?
00:03:25I'm saying it's okay.
00:03:27It's okay.
00:03:29He said it's a sales department.
00:03:31I'm saying it's okay.
00:03:33This is the operation.
00:03:35You can do 40 AC.
00:03:37I'm saying it's okay.
00:03:39You can do 40 AC.
00:03:41You can do 40 AC.
00:03:43You can do 40 AC.
00:03:45Now, do this.
00:03:47Select DPTL no?
00:03:49I'm saying it's okay.
00:03:51I'm saying it's okay.
00:03:53Select DPTL no from.
00:03:55I'm saying it's okay.
00:03:57Select DPTL no from.
00:03:59from dpt where the name is equal to sales
00:04:11now it shows us 30
00:04:23now we are here
00:04:28we will say that we will know but if we have 4-5 records then it will be fine
00:04:33no no sir, we should do the dynamic as you have made
00:04:37find out imply be the highest salary in the company
00:04:48it will be from one table
00:04:53second highest
00:04:55it will be 2-3 be
00:05:00also
00:05:01select
00:05:06select
00:05:08we will do the entry
00:05:11select
00:05:14star
00:05:15max
00:05:16value max
00:05:19then put in the bracket
00:05:23bracket
00:05:24from
00:05:25emp
00:05:26select
00:05:27number
00:05:28drop
00:05:29按
00:05:33select
00:05:34select
00:05:36select
00:05:37select
00:05:38select
00:05:40select
00:05:41click
00:05:43select
00:05:45then press
00:05:47select
00:05:48select
00:05:49select
00:05:50select
00:05:51select
00:05:53a lesser less than bracket location select max save from bracket save bracket one from
00:06:13in
00:06:18I said
00:06:20funny serum in next second sale
00:06:23I don't
00:06:26Oh
00:06:28yeah
00:06:30tickets for a week at the
00:06:32and
00:06:34I'm gonna find the implied
00:06:36Adamic now
00:06:38I need it.
00:06:43Implike of high-doubt.
00:06:44I can't believe it.
00:06:45Yes.
00:06:48Because if we don't know the second max cell,
00:06:51then we'll remove it.
00:06:53Then, let's write it.
00:06:55Select...
00:06:56Yes, select key name from EMP.
00:06:59Yes, sir.
00:07:01Where?
00:07:02As cell.
00:07:04Which cell?
00:07:09Like this?
00:07:10Yes.
00:07:11Yes, sir.
00:07:12Yes, sir.
00:07:13Okay.
00:07:14This is a good thing.
00:07:16Now, I'm trying to connect 2-3 records.
00:07:22This is our...
00:07:34Smith 1, Alan 1, Bard 1, Jones 1.
00:07:40Okay.
00:07:41So, I've done these results.
00:07:43I just have done some amounts.
00:07:45I've done 3,000 for two times.
00:07:48And...
00:07:49I've done 5,000 for two times.
00:07:54I've done 850 for two times.
00:07:59And here is the third area of NOSA.
00:08:03Which record or manager?
00:08:12Employer ID, do you have a distinct object?
00:08:16Okay, let's see for primary key.
00:08:21Primary key?
00:08:23Let's change the number of primary key.
00:08:29701
00:08:39ok
00:08:45this will be wrong
00:08:47then put it in top 1
00:08:49then put it in top 1
00:08:51and then come
00:08:532
00:08:55so if you go here
00:08:59so
00:09:03order by
00:09:05sell
00:09:11ok
00:09:13second sell is coming
00:09:15ok
00:09:17second sell is coming
00:09:19ok
00:09:21but
00:09:23on unique base
00:09:25ok
00:09:27ok
00:09:29now
00:09:31we have one name
00:09:33so we can add top 1
00:09:35and then
00:09:37we can also
00:09:39give all the numbers
00:09:41if you have a row number
00:09:43according to your
00:09:44depending order
00:09:45to your
00:09:47depending order
00:09:49if you add a number to the window
00:09:51or anything
00:09:53or anything
00:10:03or anything
00:10:05or anything
00:10:07or anything
00:10:09So you are talking about the row number?
00:10:17Yes sir, let's talk about the row number.
00:10:20So here it will be 1, 2, 3, 4, 5, 6, 7, or here it will be 1, 2, 3, 4, 5, 6.
00:10:26So in the second cell then it will be 2.
00:10:33Yes sir.
00:10:35But the second highest is our unique base.
00:10:40So what will you do in this case?
00:10:45I mean this will be 1 and this will be 2.
00:10:51This will be 3, 4 and 5.
00:10:54So if it will be the requirement, then what are you doing in your mind?
00:10:59I'd gold and you can see that.
00:11:02So you can see it in the 2nd one.
00:11:06So your next body is below.
00:11:08So if you want to do this level of the wrong chord, you earn.
00:11:11I use them to find them, you'll lift me.
00:11:14To send the pistol from the risk 경우 in the second face.
00:11:16So do something with me.
00:11:18I can dance rank
00:11:30dance rank
00:11:32I need to put a meter
00:11:34I will do select
00:11:38celery
00:11:40ok
00:11:42Select celery
00:11:44I would like to add E name, cell, to show it, and then, dance rank, and here, over, will it be like this?
00:11:59Yes sir, order by cell descending.
00:12:06I would like to add DNS rank.
00:12:09I would like to add the cell in the cell.
00:12:15Did you write that?
00:12:17Yes sir.
00:12:18Yes sir.
00:12:19Yes sir.
00:12:20It's coming.
00:12:23What will you write now?
00:12:28Now sir sir.
00:12:29Why sir, dance rank equal to?
00:12:32Or, put it in CT and then put it in CT.
00:12:35It won't take directly.
00:12:37I will do it in CT.
00:12:41Or, put it in CT.
00:12:43Or, put it in CT or then?
00:12:44I will create a subcubilee.
00:12:46With CT in match.
00:12:49Select Enam, cell from, city where, DNS, RMK is called.
00:13:04I will create a subcubilee.
00:13:05This is another thing.
00:13:07It has been another thing.
00:13:09The benefits of this is that, if you have to add another, you have to add 2, add another, and then, add 4.
00:13:18Well, this is easy.
00:13:20You can try 5,5,6.
00:13:22So, you need to put a 6.
00:13:24So, this is our show.
00:13:28This is my show.
00:13:30This is my show.
00:13:32This is my show.
00:13:34This is my show.
00:13:36This is my show.
00:13:38Now, we will say this is the right.
00:13:40Now, this is simple, low rank.
00:13:42Yeah, simple rank.
00:13:44Row number here.
00:13:46You will jump from rank and you will jump from rank and you will jump from rank.
00:13:54Because the second one is the one.
00:13:58Display the average salary and if display the average salary of each job title around 2 decimal.
00:14:10Do you see the job as well?
00:14:16All of these are the ones that we are going to do right now.
00:14:23Display the average salary of each job title around 2 decimal.
00:14:29All of these are the ones that are in the job.
00:14:33And we will go to the job.
00:14:36Yes, job. Now let's see if you know about job.
00:14:41It's okay, sir.
00:14:42Let's write select.
00:14:46Sir, write job.
00:14:50Forma.
00:14:52Sir, write average.
00:14:54VBG.
00:14:58Back to start.
00:15:01Tell.
00:15:03Then, after.
00:15:04Yes, sir.
00:15:06We need to put round here, sir.
00:15:08We need to put round here.
00:15:09We need to do one step.
00:15:14Okay, sir.
00:15:15Write it.
00:15:16Average cell.
00:15:17As the average cell.
00:15:23From.
00:15:26ELP.
00:15:29Group by job.
00:15:30Good job.
00:15:33Isma, sir.
00:15:34Aap ne eek baar batae tha na.
00:15:37Into.
00:15:38Farke one.
00:15:40One point.
00:15:41Double zero.
00:15:42Se kar diji.
00:15:43One point.
00:15:44I have a decimal.
00:15:45To value.
00:15:49Isma, i.e.
00:15:50Aap ne.
00:15:51Aap ne.
00:15:53Aap ne.
00:15:54Aap ne.
00:15:55Aap ne.
00:15:56Aap ne.
00:15:57Aap ne.
00:15:58I am not sure how to do this.
00:16:05First, round zero, see the decimal huttrees.
00:16:12This is right, so I am not sure how to do this.
00:16:17Yes, I am not sure how to do this.
00:16:21We have done round values but we have not done this.
00:16:28It's not coming. What is the deal?
00:16:34I don't know how much it is.
00:16:36I don't know how much it is.
00:16:40It's a decimal two.
00:16:44It's a decimal two.
00:16:47If I put it in integer,
00:16:51it will be possible.
00:16:53We will leave it.
00:16:57We will change it.
00:17:07But if we want to show it,
00:17:09what do we do?
00:17:18I don't see the option.
00:17:20Do we can cut it.
00:17:21If we cut it in a point,
00:17:22we will let two characters cut it.
00:17:24Do you have to do it?
00:17:26Do you have to cut it in a text format?
00:17:30Yes.
00:17:31Do you have to cut it in a text format?
00:17:33Yeah, you can do it like that too.
00:17:38Let me show you how many points you can do.
00:17:44Display the name of employee who joined after the employee's meet.
00:17:55How do you make this?
00:18:00Let me show you how many points you can do.
00:18:07Let me show you how many points you can do.
00:18:11From
00:18:14EMP
00:18:18Hired
00:18:21Where?
00:18:25Where?
00:18:27Greater than
00:18:30Bracket means daljajay sir.
00:18:32Select
00:18:34Hided
00:18:39From
00:18:40EMP
00:18:42Where
00:18:45E name
00:18:48Smith
00:18:59Equal to Smith
00:19:01What is the date of your name?
00:19:14What is the date of your name?
00:19:1617
00:19:1717
00:19:1818
00:19:2120
00:19:2718
00:19:2821
00:19:2920
00:19:3020
00:19:3121
00:19:3321
00:19:3420
00:19:3521
00:19:3621
00:19:3821
00:19:3922
00:19:4022
00:19:4122
00:19:4222
00:19:4322
00:19:4422
00:19:4522
00:19:4622
00:19:4723
00:19:4823
00:22:21Select imply who do not have manager.
00:22:30This will be simple.
00:22:34This will not be the manager.
00:22:43This will be simple.
00:22:51This will be simple.
00:22:57Yes, simple.
00:23:02If you don't have manager id, it will be simple.
00:23:20Another question.
00:23:22Identify customer who placed more than 5 orders.
00:23:27But gave a rating for only one order in the last six months.
00:23:36This means that the customer has passed the last six months.
00:23:45But the rating has only one order.
00:23:47The rating has only one order in the last six months.
00:23:56The rating has only one order.
00:24:00The rating has only one order.
00:24:07The rating has only one order.
00:24:09The rating has only one order.
00:24:15The rating has only one order.
00:24:24The rating has only one order.
00:24:30Select, Restore, Orders
00:24:40This has the rating of 3 customers
00:24:54customer ID 1, 3 or 4, customer 1, 2, customer 1 or 2, 3 or 4, by default one year, but this
00:25:12one year and a half, thank you sir, so sir, rodata and rodata, rodata, rodata, rodata, rodata
00:28:52Exactly.
00:28:56Start also.
00:28:58Yes, I will start again.
00:29:02As a order count.
00:29:12From.
00:29:14From.
00:29:16Orders.
00:29:20Having.
00:29:22From.
00:29:24Group by.
00:29:26Group by.
00:29:28Customer name.
00:29:38Having.
00:29:42This count.
00:29:44Count star.
00:29:46Greater than 5.
00:29:505.
00:30:08ID.
00:30:10Easy to find.
00:30:12Easy to find.
00:30:14What do I do?
00:30:18In the rating.
00:30:20You can give it.
00:30:22Customer ID.
00:30:24Customer name.
00:30:26It will be easy to find.
00:30:36Group by.
00:30:38No.
00:30:44No.
00:30:46No.
00:30:48I am.
00:30:50I am.
00:30:52I am.
00:30:54Okay sir, what are you doing now on the other table?
00:31:01ID wise, count minimum is equal to 1.
00:31:09Rating, sir?
00:31:12Yes sir.
00:31:14Question sir, can you tell me again?
00:31:20Okay sir, now we will put conditions on the table.
00:31:35Now we will work on the rating table, leave it.
00:31:38But this is the 6 months.
00:31:45Yes sir, now we will work on the table.
00:31:49But give ratings only last 6 months.
00:31:54Okay, the rating is given in the last 6 months.
00:31:59Okay.
00:32:00Yes sir.
00:32:01Yes sir.
00:32:02Let me tell you.
00:32:03Let me tell you, sir.
00:32:05Let me tell you, sir.
00:32:06Let me tell you, sir.
00:32:07Let me tell you, sir.
00:32:08Let me tell you, sir.
00:32:10Let me tell you, sir.
00:32:12Now we have to put conditions on it.
00:32:15Let me tell you, sir.
00:32:16Customer ID.
00:32:17Sell.
00:32:18Okay sir.
00:32:19Forma.
00:32:20Count.
00:32:21Restore.
00:32:22Okay sir.
00:32:23Okay sir.
00:32:24Forma.
00:32:25Count.
00:32:26Restore.
00:32:27Okay sir.
00:32:28Forma.
00:32:29Count.
00:32:30Restore.
00:32:32Count.
00:32:33Restore.
00:32:34Count.
00:32:35Restore.
00:32:44Sir.
00:32:48As a rating count give dije.
00:32:50Sir, give a rating count like this
00:33:11Sir, group by
00:33:14Put a pair of pair
00:33:16Group by, put a pair of pair
00:33:20Rating date
00:33:33Greater than
00:33:39Equal to
00:33:41EO month
00:33:42We will put a date
00:33:43And
00:33:47EO month
00:33:48We will manage
00:33:496
00:33:50EO month
00:33:51Is
00:33:52What is
00:33:54EO month
00:33:55Is
00:33:56EO month
00:33:57Is
00:33:58EO month
00:33:59No, so
00:34:00Dated F
00:34:01We will reach 6 months
00:34:04We will reach 6 months
00:34:05If
00:34:06EO month
00:34:07Is
00:34:08EO month
00:34:09Is
00:34:10EO month
00:34:11No, no
00:34:12But
00:34:13EO month
00:34:14How will we go to EO month
00:34:16Eo month
00:34:17Do not ask
00:34:18EO month
00:34:19It is
00:34:20EO month
00:34:24EO month
00:34:25Wait
00:34:26I
00:34:27Did
00:34:28Date
00:34:29Add
00:34:30Date
00:34:31Or
00:34:32Date
00:34:33If
00:34:34Now
00:34:35Date
00:34:36Yea
00:34:37Date
00:34:38Add
00:34:40Date
00:34:41Date add in turn world
00:34:44Yes
00:34:45Month
00:34:47Minus
00:34:49Six
00:34:50Right?
00:34:51Yes
00:34:52Six
00:34:53Yes, put it here. Get date
00:34:55Get date
00:34:57That's it
00:34:59That's it
00:35:01Sir, now we have to put group by too. I don't need to take it.
00:35:06Take it next line
00:35:11Group by customer id
00:35:16Or sir
00:35:19Having, you have in
00:35:24Your count star
00:35:28Equal to 1
00:35:30Your count star
00:35:31The
00:35:36Direct
00:35:37We have 6 months
00:35:38We have in
00:35:40April
00:35:41We have in
00:35:42March
00:35:43We have in
00:35:44August
00:35:45We have in
00:35:46March
00:35:47We have in
00:35:48March
00:35:49We have in
00:35:50March
00:35:52It's 6 months now, Augustine, September, July, April, May, June, July.
00:35:59Yes sir, okay, both of them.
00:36:01Now we will group them, sir.
00:36:05How do we do it?
00:36:06We will put them in the same place.
00:36:11Both of them, sir, go to the city and go to the same place.
00:36:15That's it, that's it.
00:36:17I have written here, with CTEHK.
00:36:22First one I have written here, CTEHK.
00:36:28Okay?
00:36:30Racket A, CTEHK.
00:36:40I say there,
00:36:43select a star from CTEHK.
00:36:52A has come.
00:36:54A has come.
00:36:56A has come.
00:36:58Okay?
00:37:00Right?
00:37:02Okay, sir.
00:37:04Now we will join in the customer ID, where it is equal.
00:37:08What is this?
00:37:09So, what do you have written?
00:37:10Select.
00:37:11Select.
00:37:12Select.
00:37:13Select.
00:37:14Select.
00:37:15CTEHK.
00:37:16CTEHK.
00:37:17CTEHK.
00:37:18Customer name.
00:37:19Customer name.
00:37:20Customer name.
00:37:21Customer name.
00:37:22Customer name.
00:37:23Customer name.
00:37:24Customer name.
00:37:25I will do this.
00:37:26And,
00:37:27order count.
00:37:28Order count.
00:37:29Order count.
00:37:30Order count.
00:37:31Order count.
00:37:32I will do this.
00:37:33I will do this.
00:37:34CTEHK.
00:37:35CTEHK.
00:37:36CTEHK.
00:37:37CTEHK.
00:37:38From.
00:37:39CTEHK.
00:37:40CTEHK.
00:37:41Data count.
00:37:42Order count.
00:37:43CTEHK.
00:37:44CTEHK.
00:37:45Asset.
00:37:46CTEHK.
00:37:47From.
00:37:48Dot.
00:37:49Rating count.
00:37:51I will do this.
00:37:52From.
00:37:53CTEHK.
00:37:54We will do it.
00:37:55From.
00:37:56CT1.
00:37:57Om CT1
00:38:20Did you guys join?
00:38:27ct2 on ct1.customerid equal to ct2.customerid
00:38:52ct1.customerid
00:38:59ct1.customerid
00:39:12ct1.customerid
00:39:17ct1.customerid
00:39:24ct1.customerid
00:39:31ct1.customerid
00:39:38ct1.customerid
00:39:47ct1.comerid
00:39:48if or rating cardo six months care and that
00:39:55it can't take a reading
00:39:59already are still reading it's a reading number
00:40:02getting out cardia or other in my school
00:40:07satari card other Raju name it already
00:40:13it's a rating that got two and this is the job of your team is cut to
00:40:19go together
00:40:23your Raju can not make it a video I love
00:40:27I'm gonna win on me I love it quite can I stay a shortcut
00:40:33I will show you the same thing.
00:40:40What is the same thing?
00:40:44Okay, it's done.
00:40:47It's done.
00:40:52It's done.
00:40:54I will show you the same thing.
00:40:58Delete the raw.
00:41:02Rating somewhere Rating ID is a call
00:41:088
00:41:09Haan?
00:41:12How is this?
00:41:17Okay, what is Rating ID?
00:41:23Rating ID
00:41:25Rating ID
00:41:31Rating ID
00:41:33Now I will go and see
00:41:35Rating ID
00:41:40Rating ID
00:41:42Rating ID
00:41:45This type of question is not good
00:41:49No
00:41:50It is good
00:41:53What is this?
00:41:58What is this?
00:42:00Identified customer who paid case for all rights in the last 6 months
00:42:10Okay
00:42:12Now, for it
00:42:14Rights
00:42:15Right payment
00:42:17This is
00:42:18Right payment
00:42:21This is
00:42:22It's
00:42:23It's
00:42:24In this
00:42:25It has
00:42:26What is this?
00:42:28customer ID, customer name, mode of cash, ride date
00:42:49I am saying that the customer has paid cash for all rights in the next 6 months
00:42:59in the last 6 months, what have you done with the cash?
00:43:08I have paid cash for all rights
00:43:10Tell me
00:43:19I am going to go out
00:43:44So, LinkedIn select
00:43:49Yes.
00:43:52The customer's name?
00:44:03Sir, will you use the case, sir?
00:44:07Tell me, I will use the case.
00:44:112-3 ways to use the case without the case.
00:44:16It will become a count.
00:44:19It will become a count, sir.
00:44:20One, our count will become a count.
00:44:33Let me tell you, sir.
00:44:43Select?
00:44:44I will write the customer name.
00:44:49I will write the customer name.
00:44:51And the customer name.
00:44:54And sir.
00:44:59We just want to count on the case.
00:45:01How do we write the case?
00:45:02What do we have to count?
00:45:05We just want to count on the case.
00:45:07How do you write the case, sir?
00:45:08How do we write the case?
00:45:09How do we write the case?
00:45:10How do we write the case, sir?
00:45:14Okay, sir.
00:45:15You can write the case, sir.
00:45:16Count, start.
00:45:17Or as a count or sir, pher ligdijijay sir last name, yes, we are, we are, abhi ma
00:45:38Let's get started.
00:45:39Group by.
00:45:40Customer name.
00:45:41Also.
00:45:42Also for having count star.
00:45:44Oh!
00:45:45Next.
00:45:46Next.
00:45:47Next.
00:45:48Next.
00:45:49Next.
00:45:50Next.
00:45:51Next.
00:45:52Next.
00:45:53Next.
00:45:55Next.
00:45:56Next.
00:45:57Next.
00:45:58Next.
00:45:59Next.
00:46:00Next.
00:46:01Next.
00:46:02Next.
00:46:04Next.
00:46:05Next.
00:46:06Next.
00:46:07Next.
00:46:08Let me take my hand, sir.
00:46:10No, no, having counter...
00:46:12Why are you taking counter?
00:46:14Why are you taking counter?
00:46:18Tell me, sir.
00:46:20It's true, sir. Equal to write, sir.
00:46:26Now, sir, start the bracket.
00:46:28Oh, it's long.
00:46:32No, no, sir. It's very easy.
00:46:34I'm telling you, sir, it will come.
00:46:36Let me write, sir.
00:46:38Count start.
00:46:42Here, again, counter start.
00:46:49Yes, yes.
00:46:50Black fit, sir.
00:46:52Now, sir, let me write as.
00:46:57No, from.
00:46:58Yes, yes, yes.
00:47:00What do you want to write?
00:47:02No, sir, I'm telling you.
00:47:04Yes, sir.
00:47:05Yes, sir.
00:47:06Yes, sir.
00:47:07Now, what do you want to write?
00:47:08Count start.
00:47:09Count start.
00:47:10Count start.
00:47:11Just.
00:47:12This sentence is wrong.
00:47:13No, sir.
00:47:14No, sir.
00:47:15No, sir.
00:47:16Then, from.
00:47:17From.
00:47:18From.
00:47:19Para.
00:47:20Ende radish.
00:47:25Okay.
00:47:26Try.
00:47:27ани.
00:47:28Lordride payment.
00:47:30Pardon.
00:47:32Group by customer name.
00:47:34Okay.
00:47:35Talk to us.
00:47:37They say.
00:47:42They say.
00:47:43It will be multiple in his hand.
00:47:52It will be joint.
00:47:59He has taken it here.
00:48:01He is telling us to tell customers how to cast.
00:48:10Right?
00:48:13Do I have to carry out of him?
00:48:19We can also do it with the join.
00:48:21Who paid cash for all riders.
00:48:24Who paid cash for all riders.
00:48:27He has cashed everywhere.
00:48:29So, I have given here a customer name.
00:48:31And there was another.
00:48:32I have given here one command.
00:48:34The two things.
00:48:36And, if I substitute count...
00:48:40and I will show you the name of the customer name and the talent mode.
00:48:56This is the name of the customer name and the talent mode.
00:49:00This is the name of the customer name.
00:49:06I am going to write down here.
00:49:13I am going to write down here.
00:49:20I am going to write down here.
00:49:24we need to count on the base
00:49:32what do you say?
00:49:34customer id
00:49:36name is not a name
00:49:40we need to name
00:49:44start
00:49:50Account
00:49:52Account
00:49:53Number
00:49:54Customer
00:49:56Time
00:49:58Demise
00:50:10Youtube
00:50:20I am getting a CT
00:50:24I am getting a CT
00:50:28or make it from another
00:50:32I am getting a CT
00:50:36I am getting a CT
00:50:40I am getting a CT
00:50:44sorry sir, I am getting a CT
00:50:46I am getting a CT
00:50:50I am getting a CT
00:50:52I am getting a CT
00:50:54but we are getting a CT
00:50:56I am getting a CT
00:50:58but we are getting a CT
00:51:00for that
00:51:02we will use the CT
00:51:04we will show the case and credit
00:51:06let's go
00:51:08let's go
00:51:10here
00:51:12I am getting a CT
00:51:14Here I will put rank. Sorry, rank is not.
00:51:19Roar number.
00:51:22Roar number over. Ordered by customer name.
00:51:29Okay?
00:51:32As.
00:51:33Okay sir.
00:51:34Roar number over.
00:51:38Partition by sir.
00:51:44Partition by.
00:51:46We are not.
00:51:47Okay.
00:51:48So, here.
00:51:50What is here?
00:51:52By.
00:51:56Customer name.
00:52:02Roar number over.
00:52:04Roar number over.
00:52:06Roar number over.
00:52:08Roar number over.
00:52:10Roar number over.
00:52:12Roar number over.
00:52:13Roar number over.
00:52:14Roar number over.
00:52:15Roar number over.
00:52:16Roar number over.
00:52:17Roar number over.
00:52:18Roar number over.
00:52:19Roar number over.
00:52:20Roar number over.
00:52:21Roar number over.
00:52:22Roar number over.
00:52:23Roar number over.
00:52:24Roar number over.
00:52:25Roar number over.
00:52:26Roar number over.
00:52:27Roar number over.
00:52:28Roar number over.
00:52:29Roar number over.
00:52:30Roar number over.
00:52:31Roar number over.
00:52:32Roar number over.
00:52:33Roar number over.
00:52:34Roar number over.
00:52:35Roar number over.
00:52:36Roar number over.
00:52:37Roar number over.
00:52:38Roar number over.
00:52:39Roar number over.
00:52:40Roar number over.
00:52:41Roar number over.
00:52:42Roar number over.
00:52:43Select customer, account, start as cst, clt, clt, clt, clt, clt, clt, clt, clt, clt.
00:53:13Now select Reader, clt , vuhu clt, clt, clt, clt, clt, clt, clt, clt, clt, clt, clt.
00:53:25DoctorHA me.
00:53:35Having , uя君 n تع و qi ez me ur karver ho ga hya steamer.
00:53:43Account is equal to 1 and PAI tenant board is equal to CASH.
00:54:07It works and does not work.
00:54:14I am going to explain how it works.
Recommended
1:27:55
|
Up next
1:04:25
1:27:01
52:20
35:08
1:50:38
16:02
1:26:15
46:52
1:30:13
1:08:26
1:08:17
1:44:20
19:03
1:03:00
1:31:31
1:11:49
1:31:40
1:08:19
1:58:00
1:10:48
1:20:45
9:47
Be the first to comment