- 6/23/2025
14 SQL Practice Session 15 Jun 2025 Part - 1
source file :- https://drive.google.com/file/d/13F9YHtxVogkJdqL_rX4SWc-XSw2jYeSR/view?usp=sharing
source file :- https://drive.google.com/file/d/13F9YHtxVogkJdqL_rX4SWc-XSw2jYeSR/view?usp=sharing
Category
📚
LearningTranscript
00:00:00I'm going to go to the other class.
00:00:05So, our...
00:00:10This is a table made by the person's name of the person's name of the person's name.
00:00:37this is what age is first name last name age salary location
00:01:07and now I'm going to go to the next level of the road
00:01:13this is what age is first name
00:01:20this is what age is first name
00:01:24this is what age is first name
00:01:29this is what age is first name
00:01:32I don't know how to do it.
00:02:01Why is this red?
00:02:05Why is this red?
00:02:09It's not working.
00:02:11This is also a bracket.
00:02:13This is also a bracket.
00:02:15This is from 32 to 32.
00:02:19Everything is fine.
00:02:21Here is a bracket.
00:02:23Here is a bracket.
00:02:25I will do it.
00:02:27I will do it.
00:02:31Incorrect sentence near Mohit.
00:02:35What is this?
00:02:39What is this?
00:02:41I don't know.
00:02:43I don't know.
00:02:45I don't know.
00:02:47I don't know.
00:02:57I don't know.
00:02:59I don't know.
00:03:01Oh, I got it.
00:03:03Let me open.
00:03:05It's already Mohit.
00:03:07No.
00:03:09Let's see here.
00:03:11Noida, there's no apostrophe.
00:03:13Noida, there's no apostrophe.
00:03:15Okay, okay.
00:03:17Where is this?
00:03:19Where is this?
00:03:21Recording.
00:03:23Yes, I got it.
00:03:25Noida, there's no apostrophe.
00:03:27Okay.
00:03:29So, we've made a table.
00:03:31I'm doing this.
00:03:33Now, I'm doing this.
00:03:35I'm doing this.
00:03:37I'm doing this.
00:03:39If you're doing this,
00:03:41you don't use this.
00:03:43You're doing this.
00:03:45I'm doing this.
00:03:47Find the implied salary.
00:03:49Rank from highest to lower.
00:03:51Tell me.
00:03:53Salary rank from highest to lower.
00:03:55Tell me.
00:03:57Salary rank from highest to lower.
00:04:05Is this duplicate salary?
00:04:07Do you have duplicate salary?
00:04:09Do you have duplicate salary?
00:04:11Do you have duplicate salary?
00:04:13Distinct salary.
00:04:15Select this
00:04:31salary.
00:04:33From employee.
00:04:35Order by.
00:04:41Yes, but this is a selling price.
00:04:44Yes, I will.
00:04:46Now, where are you from?
00:04:49No, no, here you will be all information when you talk about ranking.
00:04:56The data is still there.
00:05:00Okay, sir, you are saying that data will be still there, but the same ranking is the same.
00:05:05Yes, yes, yes.
00:05:08कавно रखow icons के कि पता запार ने तो देखिये तो आपको तो अमिbits iq but
00:05:35My name is H
00:05:37A
00:05:38A
00:05:42A
00:05:43A
00:05:44I
00:05:46I
00:05:48I
00:05:55I
00:05:57I
00:05:58I
00:05:59I
00:06:00I
00:06:01I
00:06:02I
00:06:03I
00:06:04It's not the answer.
00:06:15I understood.
00:06:17But the reason this has something so important is not the right ranking of the salary.
00:06:25is
00:06:28recommended to duplicate
00:06:31that is not
00:06:32because the role of the
00:06:34data
00:06:35has no meaning
00:06:37as
00:06:38you can
00:06:40add
00:06:41all
00:06:42of
00:06:43the
00:06:44sequence
00:06:45will
00:06:46be
00:06:47right
00:06:48Yes sir, it is a mandatory to use order-wise class where row number rank and dance rank
00:07:01use in Q&A. If you have row number rank and dance rank use in Q&A, then order-wise
00:07:08and then order-wise and then order-wise. Find the 5th highest salary using nested
00:07:18Q&A. Sir, how do you solve it? No, no, the first thing is like this. Now,
00:07:24if you change the duplicate to duplicate, tell me how it will happen. If I write
00:07:31to DSTNCT Distance salary,
00:07:39then this one will be taken, it has shifted! It doesn't have to be removed.
00:07:45Where I got fled?
00:07:48OK.
00:07:48Then this is nameless feature of all thecard 앤
00:07:51this feature is also a feature that will give all the set
00:08:00now let's see
00:08:03disdinc selected distance salary from EMP EMP
00:08:12imply
00:08:15it's coming from here
00:08:18but if it will happen again
00:08:23if I will give it to the row number
00:08:26but it has to be removed
00:08:29this is the last one
00:08:32order by salary
00:08:35order by salary
00:08:39descending
00:08:42I can add this rank, then I will put it in the same place, salary, row, number,
00:08:56it will be like this, order by salary, salary, salary, salary, salary, salary, salary,
00:09:10I will put a distinct cell.
00:09:13In this?
00:09:14Yes, sir.
00:09:16DSTNCT
00:09:19This is not possible.
00:09:21This is not the case.
00:09:24Okay.
00:09:25We will do this.
00:09:27We will do this.
00:09:28We will copy this.
00:09:30We will do this.
00:09:31We will write select star,
00:09:34row number
00:09:39Is it okay?
00:09:41I will put it in the bracket.
00:09:44I will put it in the bracket.
00:09:46I will put it in the bracket.
00:09:48One second.
00:09:50We will do this.
00:09:52Select star as qq.
00:10:01From, sir.
00:10:03From, sir.
00:10:04From, sir.
00:10:05From, sir.
00:10:06From, sir.
00:10:07From, sir.
00:10:08From, sir.
00:10:09How, sir?
00:10:10It is why you can define those qq.
00:10:13From, sir.
00:10:18Order by
00:10:19Clouding evaluation field snap function.
00:10:20Um, sir.
00:10:26The column danny jump is bigger, and it'sbare.
00:10:27I will not give the name of the column, sir.
00:10:32Oh, oh, oh, oh.
00:10:34When I took the star, why would I give the name of the column?
00:10:39It's okay.
00:10:41It's okay.
00:10:44This is our subcurement.
00:10:48When this is complete, when I copied it,
00:10:54select star from here.
00:10:57Add QQ.
00:11:02It's okay.
00:11:08It's okay.
00:11:12You can close it.
00:11:15But this is a table.
00:11:19We will remove it.
00:11:22It's okay.
00:11:24It will come.
00:11:27It's okay.
00:11:29Order by Closet.
00:11:31It's okay.
00:11:33Order by Closet.
00:11:35Salary description.
00:11:37Sponsored by Closet.
00:11:38They will be positioned as well.
00:11:40No, it is going to be a name.
00:11:41It's okay.
00:11:42It is coming.
00:11:43Now, I'm going to take it.
00:11:46Yeah.
00:11:47Now, I took it.
00:11:48It is now.
00:11:49I took it.
00:11:50I took it.
00:11:51I took it.
00:11:52I was seeing the error.
00:11:53That was the error from the order of the column.
00:11:55It changed what you have here.
00:11:57What happened from this column?
00:11:58It changed which down to the right column.
00:12:00It changed.
00:12:01It changed.
00:12:02It changed.
00:12:03It changed.
00:12:04the sequence is different, but it has been shortened to the celery.
00:12:12Okay, it's different.
00:12:16Now, if I take the row number,
00:12:24is
00:12:26oh
00:12:28oh
00:12:30oh
00:12:32oh
00:12:34salary
00:12:36dsc
00:12:38is
00:12:40okay
00:12:42I don't know how much we can do this type of rank, but it will not be true because the row
00:12:58number is just a work. You can start the row from one to one and the sequence will increase.
00:13:05the highest. Find the 5th highest salary. Select a star from imply.
00:13:26The highest salary is $18,500.
00:13:47Here I am going to the YS, sir.
00:13:52What?
00:13:53Okay, sir.
00:13:55One, two, three, four, five, four, six.
00:13:57It's all down and it's all down.
00:13:59It's all down, up to 800-500.
00:14:01Yes.
00:14:10Okay, now tell me how will it come for the 5th salary?
00:14:15Sir, we will add one column, and we will add the row number.
00:14:22Yes, row number, over, order by salary DSA, as RNK.
00:14:42I am going to add it.
00:14:45Yes, I am going to add it.
00:14:49But, see, it's all I have to add.
00:14:53And the distinct value of the value.
00:14:56Sir, let me remove this.
00:15:03Just add the value of the value of the value of the value of the value.
00:15:09so you will get the number of the number of the number of the number?
00:15:14I will get it.
00:15:16Do you need it?
00:15:18I will do it.
00:15:21Then you will do everything.
00:15:26Distinct salary from imply.
00:15:30Is it coming?
00:15:34select star from bracket as qq
00:15:48now we have road number
00:15:57it can be dense and dense rank
00:16:00but we are doing this
00:16:04order by salary
00:16:08as rnk
00:16:12yes sir
00:16:16yes sir
00:16:18is equal to five
00:16:22yes
00:16:24yes
00:16:26yes
00:16:28yes
00:16:30yes
00:16:32yes
00:16:34yes
00:16:36yes
00:16:38yes
00:16:40yes
00:16:42yes
00:16:44yes
00:16:46yes
00:16:48yes
00:16:50yes
00:16:52yes
00:16:54yes
00:16:56yes
00:16:58yes
00:17:00yes
00:17:02yes
00:17:04yes
00:17:06yes
00:17:08yes
00:17:10yes
00:17:12yes
00:17:14yes
00:17:16yes
00:17:18yes
00:17:20yes
00:17:22yeah
00:17:24yes
00:17:26yes
00:17:28yes
00:17:383 from imply select star from cell
00:17:57this is coming with the edge
00:18:15this is coming with the edge
00:18:25where rnk is equal to 5
00:18:35find out salary from highest to lowest for each location
00:18:53select star from a emp location by salary
00:19:02from
00:19:06star select star
00:19:11कि और कॉमआ यस्टो लोस्ट पिछ लोकेशन में तो सर इसमें और भाइधि लिग दिघ्ट लिग दिए कि डाइक लगा सकते हैं तो
00:19:30I got a comma over
00:19:33yeah, I got a comma.
00:19:34Star Kema.
00:19:35Why?
00:19:39Is there star?
00:19:40I got a comma.
00:19:42I got a comma.
00:19:42I got a comma.
00:19:43Okay.
00:19:44All right.
00:19:45I got a comma over.
00:19:46Okay, I got a comma.
00:19:47Sorry.
00:19:49Partition.
00:19:50Location.
00:19:57Location.
00:19:58Location.
00:20:00Yeah, order by salary descending.
00:20:06No, sir, it's inside.
00:20:08Order by salary descending.
00:20:12It's okay, I'm doing this inside.
00:20:15Order by salary.
00:20:19Salary DS, DS.
00:20:23Sir, salary descending.
00:20:26Tell me, there's an error.
00:20:33Let's see.
00:20:36Where is the salary?
00:20:43Select SRA.
00:20:54Select SRA.
00:20:59What's the difference?
00:21:01Where are the salary?
00:21:07Where are the salary?
00:21:14Your salary?
00:21:16Your salary.
00:21:20The salary.
00:21:21The salary.
00:21:26The salary means it's all up.
00:21:29The salary means it's all up.
00:21:33I'm so out of time.
00:22:03Oh
00:22:24Oh
00:22:26In this situation we don't have to fix the wrong number and we need to fix the wrong number as well.
00:22:37I am
00:22:40I am
00:22:44I am
00:22:46Select star row number
00:22:48order
00:22:51order
00:22:52I
00:22:54I
00:22:55I
00:22:56I
00:22:57I
00:22:58I
00:22:59I
00:23:01I
00:23:02I
00:23:03I
00:23:04I
00:23:06I
00:23:08I
00:23:10I
00:23:12I
00:23:14I
00:23:16I
00:23:18I
00:23:20I
00:23:22I
00:23:24I
00:23:26I
00:23:28I
00:23:30I
00:23:32I
00:23:34I
00:23:36I
00:23:38I
00:23:40I
00:23:42I
00:23:44I
00:23:46I
00:23:48I
00:23:50I
00:23:52I
00:23:54I
00:23:56I
00:23:58I
00:24:00I
00:24:02I
00:24:04I
00:24:06I
00:24:08I
00:24:10I
00:24:12I
00:24:14I
00:24:16I
00:24:18I
00:24:20I
00:24:22I
00:24:24I
00:24:26I
00:24:28I
00:24:30I
00:24:32I
00:24:34I
00:24:36I
00:24:38I
00:24:40I
00:24:42I
00:24:44I
00:24:46I
00:24:48I
00:24:50I
00:24:52I
00:24:54I
00:24:56I
00:24:58I
00:25:00I
00:25:02I
00:25:04I
00:25:06I
00:25:08I
00:25:10I
00:25:12I
00:25:14I
00:25:16I
00:25:18I
00:25:20I
00:25:22I
00:25:24I
00:25:26I
00:25:28I
00:25:30I
00:25:32I
00:25:34I
00:25:36I
00:25:38I
00:25:40I
00:25:42I
00:25:44I
00:25:46I
00:25:48I
00:25:50I
00:25:52I
00:25:54I
00:25:56I
00:25:58I
00:26:00I
00:26:02I
00:26:04I
00:26:06I
00:26:08I
00:26:10I
00:26:12I
00:26:14I
00:26:16I
00:26:18I
00:26:20I
00:26:22I
00:26:24I
00:26:26I
00:26:28I
00:26:30I
00:26:32I
00:26:34I
00:26:36I
00:26:38I
00:26:40I
00:26:42I
00:26:44I
00:26:46I
00:26:48I
00:26:50I
00:26:52I
00:26:54I
00:26:56I
00:26:58I
00:27:00I
00:27:02I
00:27:04I
00:27:06I
00:27:08I
00:27:10I
00:27:12I
00:27:14I
00:27:16I
00:27:18I
00:27:20I
00:27:22I
00:27:24I
00:27:26I
00:27:28I
00:27:30I
00:27:32I
00:27:34I
00:27:36I
00:27:38I
00:27:40I
00:27:42I
00:27:44I
00:27:46I
00:27:48I
00:27:50I
00:27:56I
00:27:58I
00:28:00I
00:28:02I
00:28:04I
00:28:06I
00:28:08I
00:28:10I
00:28:12I
00:28:14I
00:28:16I
00:28:18I
00:28:26I
00:28:28I
00:28:30I
00:28:32I
00:28:34I
00:28:36I
00:28:38I
00:28:40I
00:28:42I
00:28:44I
00:28:46I
00:28:48I
00:28:50I
00:28:52I
00:28:54I
00:28:56I
00:28:58I
00:29:00I
00:29:02I
00:29:04I
00:29:06I
00:29:08I
00:29:10I
00:29:12I
00:29:14I
00:29:16I
00:29:18I
00:29:20I
00:29:22I
00:29:24I
00:29:26I
00:29:28I
00:29:30I
00:29:32I
00:29:34I
00:29:36I
00:29:38I
00:29:40I
00:29:42I
00:29:44I
00:29:46I
00:29:48I
00:29:50I
00:29:52I
00:29:54I
00:29:56I
00:29:58I
00:30:00I
00:30:02I
00:30:04I
00:30:06I
00:30:08I
00:30:10I
00:30:12I
00:30:14I
00:30:16I
00:30:18I
00:30:20I
00:30:22I
00:30:24I
00:30:26I
00:30:28I
00:30:30I
00:30:32I
00:30:34I
00:30:36I
00:30:38I
00:30:40I
00:30:42I
00:30:44I
00:30:46I
00:30:48I
00:30:50I
00:30:52I
00:30:54I
00:30:56I
00:30:58I
00:31:00I
00:31:02I
00:31:04I
00:31:06I
00:31:08I
00:31:10I
00:31:12I
00:31:14I
00:31:16I
00:31:18I
00:31:20I
00:31:22I
00:31:24I
00:31:26I
00:31:28I
00:31:30I
00:31:32I
00:31:34I
00:31:36I
00:31:38I
00:31:40I
00:31:41I
00:31:42I
00:31:44I
00:31:46I
00:31:48I
00:31:50I
00:31:56I
00:31:57We can object that same rank assigned to duplicate and skip the next ranking for next rank, this is the rank feature, dense rank, find the implied salary rank for highest to lowest,
00:32:19and what happens in duplicate, we can object that same rank, tell us.
00:32:29Next, select star, star, select star, comma, dense rank,
00:32:46over, bracket star, order by salary descendant, TSC, as a rank, dense rank.
00:33:09This is the set, this is the set, one, two, three,
00:33:16and both of them have given 20,000, and then 5,000, and 10,000, and both of them are the same, so 8,800.
00:33:24Okay?
00:33:26So rank and dense rank, what difference is?
00:33:29Okay, this is the difference.
00:33:33Let's talk about three.
00:33:38That is the difference.
00:33:39So rank and then size rank.
00:33:40And then number one is the number is the number?
00:33:45And then number one is the number five.
00:33:50And the number one can be the number five, so this number one is the number seven.
00:33:54So rank and then number five.
00:33:59is
00:34:03the one is
00:34:06the one is seven
00:34:08yes
00:34:10yes
00:34:11rank
00:34:13here
00:34:15sir
00:34:17one
00:34:18two
00:34:20here
00:34:21three
00:34:22here
00:34:23three
00:34:24Oh, it's 5.
00:34:27What's that? What's that?
00:34:286, 7.
00:34:30Yes, sir.
00:34:31Dance rank.
00:34:351, 2,
00:34:373,
00:34:393,
00:34:413,
00:34:423,
00:34:45Sir, here's 4.
00:34:474, 5, 6.
00:34:49What's that?
00:34:50Clear.
00:34:54Yeah, that's right.
00:34:56So rank you jump on your next rank,
00:34:58then the same rank you jump on in the next rank.
00:35:00Okay, sir?
00:35:01Yes, sir.
00:35:03Yes, sir.
00:35:04Yes, that's it.
00:35:05Ah, yes.
00:35:06There's a dense rank on your rank.
00:35:07Other rank what what the duplicate was was turned down.
00:35:12I mean,
00:35:16I mean,
00:35:17now I'm here to talk to you...
00:35:21is
00:35:23is
00:35:25a
00:35:27difference between
00:35:29row number rank
00:35:31and dance rank
00:35:32is duplicate
00:35:33rank
00:35:34data
00:35:35duplicate
00:35:36rank
00:35:37row number rank
00:35:39and dance rank
00:35:41differentiate
00:35:42other
00:35:43duplicate
00:35:44not
00:35:45number
00:35:461
00:35:47if
00:35:48I
00:35:49copy
00:35:50here
00:35:51and
00:35:52if
00:35:53I
00:35:54give
00:35:5540
00:35:5650
00:35:5760
00:35:5870
00:35:59row number
00:36:00will
00:36:01be
00:36:02as
00:36:03as
00:36:04as
00:36:05as
00:36:06as
00:36:07as
00:36:08as
00:36:09as
00:36:10as
00:36:11as
00:36:12as
00:36:13as
00:36:14as
00:36:15as
00:36:16as
00:36:18as
00:36:19as
00:36:20as
00:36:21as
00:36:22as
00:36:23as
00:36:24as
00:36:25as
00:36:26as
00:36:27as
00:36:28as
00:36:29as
00:36:30as
00:36:31as
00:36:32as
00:36:33as
00:36:34as
00:36:35as
00:36:36as
00:36:37as
00:36:38as
00:36:39as
00:36:40as
00:36:41as
00:36:42as
00:36:43as
00:36:44as
00:36:45as
00:36:46as
00:36:47as
00:36:48as
00:36:49as
00:36:50as
00:36:51as
00:36:52as
00:36:53as
00:36:54select
00:36:55as
00:36:56as
00:36:57as
00:36:58as
00:36:59as
00:37:00as
00:37:01as
00:37:02as
00:37:03as
00:37:04as
00:37:05as
00:37:06as
00:37:07yes
00:37:12yes
00:37:14underscore
00:37:15sorry
00:37:16it
00:37:17is
00:37:19here
00:37:20okay
00:37:21yes
00:37:22I
00:37:23forgot
00:37:24forgot
00:37:25I
00:37:26did
00:37:27I
00:37:28select
00:37:29star
00:37:30from
00:37:31I
00:37:32did
00:37:33a pura as qq where dnsk rank is equal to 5
00:37:46oh yeah
00:37:59we can observe that rank is assigned to duplicate and it does not skip the
00:38:03next rank for here
00:38:07difference difference different row number assigned for each row and difference it does not
00:38:13end in a value where there is a duplicate
00:38:22similar similarity between row rank or dnsk rank where there is no duplicate
00:38:27is not duplicate so row number rank or dnsk rank same output
00:38:35as a ranking
00:38:37Okay?
00:38:39Okay, sir.
00:38:41Now let's see this.
00:38:45Implied table.
00:38:49There is a repeat question.
00:38:53This is our data.
00:38:57Implied table.
00:38:59Data is coming.
00:39:01Now we are saying
00:39:03Top three roads.
00:39:05Let's play ranks of
00:39:07Implied based on salary.
00:39:09Tell us.
00:39:13Data is coming.
00:39:15Is it?
00:39:17Is it?
00:39:19Is it?
00:39:21Is it?
00:39:23Is it?
00:39:25Is it?
00:39:27Is it?
00:39:29Is it?
00:39:31Yes.
00:39:33Is it for ranking?
00:39:34Is it?
00:39:35Under rates?
00:39:36Select.
00:39:37Select.
00:39:38Start.
00:39:39Search.
00:39:41Select.
00:39:43Select-star.
00:39:44Set.
00:39:45Launch.
00:39:47Camera.
00:39:48Rank.
00:39:49Okay.
00:39:51Over.
00:39:52Over.
00:39:54take care
00:39:58sir over over
00:40:06sir order by
00:40:10cell descending
00:40:15referral as a whole from emp
00:40:23i say
00:40:24आ गया लेकिन इसमें
00:40:27हाई डूबलिकेट देखो यह दोनों डूबलिकेट है
00:40:33ठीक है आप करो फिर करते हैं फिर करो ठीक है यहां तक आ गया अब
00:40:38oh
00:40:40yeah
00:40:42yes
00:40:44yes
00:40:46hey
00:40:48can
00:40:50select
00:40:52star
00:40:54paste
00:40:56qq
00:40:58how
00:41:00and
00:41:02and
00:41:04मने इतना जाने की जरुती है निये ऑन तॉप ठी लगा तो यहाँ पर अच्छा तो यह
00:41:13फस्ट बाले में ही काम हो जाएगा आरश यहाँ पर लिच्टाफ थी एंट टॉप थी ले लगवे लेकिन यह हो गया गरबद हो रहा
00:41:29I think it's 3,000-3,000 is the same as I said, if I said that it's 3,000-3,000 is the same,
00:41:43it's okay. Otherwise, rank is the same place.
00:41:51I think it's better than that.
00:41:59Top 3,000-3,000 is the same place.
00:42:05When it's the same place, it's the same place.
00:42:10It's the same place, it's the same place.
00:42:21We have seen the top 3 records, but we have seen the top 3 records.
00:42:25The output is not correct.
00:42:28Top 3 means that the top 3 records are the same place,
00:42:35so we can get some money from the top 3.
00:42:40Yes.
00:42:41We can get some money from the top 3.
00:42:46We will get some money from the top 3,
00:42:52the pitch is the same place and if we can make a row number to the same place,
00:42:58we will have the same answer.
00:43:02so we have to do so much, then if we have to do the row number, then we have to do the
00:43:15top 3, we have to get the top 3 output, and if I have to do the top 5, then we have to
00:43:29I will tell you that when we have to do so much, then we will select dense.
00:43:37Select star from EMP. Order by salary.
00:43:47I say order by salary descending.
00:43:54We will select the top 3.
00:44:01We will select the top 3.
00:44:03We will also select our output.
00:44:05We will also select dense rank.
00:44:07But we will also select this.
00:44:15Is it okay?
00:44:16Yes, sir.
00:44:19Do we have the top 3.
00:44:26So, if we will select the 5.
00:44:28The 5.
00:44:29The 5.
00:44:30We will select the top 3.
00:44:32We will select the 5.
00:44:33The 5.
00:44:34The 5.
00:44:36so
00:44:41talk
00:44:45अ
00:44:50तो लेंगे लेकिन देखर्ध हाइस्ट शेल्री है कि में यहां पर कह रहा है तो
00:44:58I have a key returns rank of display top 5, here is the top 5 implies, but here is the
00:45:10display top 5, here is the top 5, here is the top 5, here is the top 5, here is the
00:45:20top 5, here is the top 5, here is the top 5, and you don't want the top 5ILER.
00:45:37Sir, write sir select
00:45:41Sir, write salary
00:45:53Then, comma
00:45:5510th rank
00:46:02Sir, over
00:46:07Order by sell
00:46:11Just take it
00:46:15As a rank
00:46:17From
00:46:19EMP
00:46:21Then, we will make a subquery
00:46:25Select
00:46:27Subquery
00:46:29What will you do
00:46:31No matter
00:46:33Select
00:46:35Star
00:46:37No sir, distinct star
00:46:43Distinct star
00:46:45You had a call from Ravie
00:46:47What?
00:46:49No sir
00:46:50Which Ravie sir?
00:46:51Noida
00:46:53No
00:46:54No sir
00:46:55No
00:46:56No
00:46:57No
00:46:58This is a good
00:46:59No
00:47:00No
00:47:01No
00:47:02No
00:47:03No
00:47:04No
00:47:05No
00:47:06No
00:47:07No
00:47:08No
00:47:09No
00:47:15No
00:47:16No
00:47:17No
00:47:19No
00:47:20No
00:47:21No
00:47:22No
00:47:23No
00:47:265 Oh I say
00:47:29yeah
00:47:33I am twisting
00:47:37and I'm a low
00:47:39yes
00:47:41yeah I am not
00:47:42corrupt
00:47:47Oh you said last matter 5
00:47:49last
00:47:51Yeah, so it's a good condition.
00:47:56Oh, I see.
00:47:59I am a doctor.
00:48:01I don't know.
00:48:03I don't know.
00:48:05I don't know.
00:48:07I don't know.
00:48:10Yeah.
00:48:12I am a guy.
00:48:14Yeah.
00:48:16It was on this one.
00:48:20Yes.
00:48:21Yes.
00:48:22Order by attachment.
00:48:23And directly where.
00:48:24Where.
00:48:25Rank.
00:48:26Rnk.
00:48:27Less than equal to 5.
00:48:34Then you can write it.
00:48:36Order by.
00:48:41Rank.
00:48:44That's it.
00:48:45That's it.
00:48:48And now we are going to go.
00:48:51That's it.
00:48:52This will work.
00:48:54OK.
00:48:55Let's go.
00:48:56OK.
00:48:57OK.
00:48:58It's okay.
00:48:59But here.
00:49:00I'm telling you,
00:49:03if it is not a salary.
00:49:08Let me show you.
00:49:10Clip.
00:49:13I don't know how to do rank.
00:49:15Who was it?
00:49:18Where was it?
00:49:20Distinct?
00:49:22Yes sir.
00:49:24If you see the salary,
00:49:26you can go to the salary.
00:49:30It's a bad guy.
00:49:34I need to see the salary.
00:49:36Now, where will it?
00:49:38So, if I change the salary,
00:49:42it's not coming.
00:49:44Tell me,
00:49:45I need to see the salary.
00:49:47Tell me.
00:49:49The salary is still coming.
00:49:52Where is it?
00:49:55I need to see the salary.
00:50:00I need to see the rank.
00:50:02I need to see the rank.
00:50:08Select.
00:50:10Distinct.
00:50:11So, sir,
00:50:12first of all,
00:50:13we have to do this.
00:50:15Distinct.
00:50:16Sell.
00:50:17Sell.
00:50:18Let's go.
00:50:20Select.
00:50:22Start.
00:50:23Distinct.
00:50:24Distinct.
00:50:25Distinct.
00:50:26I say.
00:50:31I say.
00:50:33I say.
00:50:34I say.
00:50:35Distinct.
00:50:36this minority molecule.
00:50:45Again,
00:50:46I say.
00:50:47I say.
00:50:48I say.
00:50:49Do not.
00:50:50You can't.
00:50:51Do not.
00:50:52Go.
00:50:53Do not.
00:50:54Go.
00:50:55Go.
00:50:56Follow me,
00:50:57Go.
00:50:58Go.
00:50:59Go.
00:51:00Search.
00:51:01Yes, sir, select salary language.
00:51:05Yes, yes, no.
00:51:08Do you like it?
00:51:09Ha ha ha.
00:51:11Is this the answer?
00:51:14Goodbye.
00:51:15Yes, sir.
00:51:17Come on.
00:51:21Group by.
00:51:24Assets.
00:51:27Sell the business itself.
00:51:31salary and rank
00:51:35sell, rank
00:51:39RNK
00:51:49I'm not sure, sir.
00:51:51I'm telling you, sir, I'm telling you,
00:51:53that group by you, sir,
00:51:55where, where,
00:51:57I'm not sure,
00:51:59but I'm also telling you,
00:52:01I'll tell you,
00:52:03you've got the grind,
00:52:05you're doing it,
00:52:07I'm telling you,
00:52:09I'm telling you,
00:52:11I'm telling you,
00:52:13when you're talking about
00:52:15the result,
00:52:17I'm telling you,
00:52:19how does this work,
00:52:21I'm telling you,
00:52:23this is the first step.
00:52:25this one.
00:52:26We have made it.
00:52:28This one will happen.
00:52:29Yes sir.
00:52:30Let's leave it.
00:52:33This one will happen.
00:52:35This one will happen.
00:52:38Top five records will happen.
00:52:41Now this one is our record.
00:52:48I need this type of record.
00:52:52Chama, Satma, Egarma.
00:52:58Yes sir.
00:52:59Tell them.
00:53:01If you have a copy,
00:53:02select star from,
00:53:12start,
00:53:15comma.
00:53:16if you have a dance rank you use religion
00:53:23dance rank kiske whisper koreo ga wo ka raha hai sirf
00:53:29by pachama saatama agarama record record ranking kataсти haimaya basakta yaha kaha hua
00:53:36kisit table mein jovi record exist kar raha hai us mein seif fifth number seventh
00:53:42in the press record the of the nomen triangle Xamarin
00:54:10I am over.
00:54:12I am
00:54:14I am
00:54:16order by
00:54:18I am
00:54:20I am
00:54:22I am
00:54:24I
00:54:26I
00:54:28I
00:54:30I
00:54:32I
00:54:34I
00:54:36I
00:54:38I
00:54:40I
00:54:42I
00:54:44I
00:54:46I
00:54:48I
00:54:50I
00:54:52I
00:54:54I
00:54:56I
00:54:58I
00:55:00I
00:55:02I
00:55:04I
00:55:06I
00:55:08I
00:55:10I
00:55:12I
00:55:14I
00:55:16I
00:55:18I
00:55:20I
00:55:22I
00:55:24I
00:55:26I
00:55:28I
00:55:30I
00:55:32I
00:55:34I
00:55:36I
00:55:38I
00:55:40I
00:55:42I
00:55:44I
00:55:46I
00:55:48I
00:55:50I
00:55:52I
00:55:54I
00:55:56I
00:55:58I
00:56:00I
00:56:02I
00:56:04I
00:56:06I
00:56:08I
00:56:10I
00:56:12I
00:56:14I
00:56:16I
00:56:18I
00:56:20I
00:56:22I
00:56:24I
00:56:26I
00:56:28I
00:56:30I
00:56:32I
00:56:34I
00:56:36I
00:56:38I
00:56:40I
00:56:42I
00:56:44I
00:56:46I
00:56:48I
00:56:50I
00:56:52I
00:56:54I
00:56:56I
00:57:02I
00:57:04I
00:57:06I
00:57:08I
00:57:10I
00:57:12I
00:57:14I
00:57:16I
00:57:18I
00:57:24I
00:57:26I
00:57:28I
00:57:30I
00:57:34I
00:57:36I
00:57:38I
00:57:40I
00:57:42I
00:57:44I
00:57:46I
00:57:48I
00:57:50I
00:57:52I
00:57:54I
00:57:56I
00:57:58I
00:58:00I
00:58:04I
00:58:06I
00:58:08I
00:58:10I
00:58:12I
00:58:14I
00:58:16I
00:58:18I
00:58:20I
00:58:22I
00:58:24I
00:58:26I
00:58:28I
00:58:30I
00:58:32I
00:58:34I
00:58:36I
00:58:38I
00:58:40I
00:58:42I
00:58:44I
00:58:46I
00:58:48I
00:58:50I
00:58:52I
00:58:54I
00:58:56I
00:58:58I
00:59:00I
00:59:02I
00:59:04I
00:59:06I
00:59:08I
00:59:10I
00:59:12I
00:59:14I
00:59:16I
00:59:18I
00:59:20I
00:59:22I
00:59:24I
00:59:26I
00:59:28I
00:59:30I
00:59:32I
00:59:34I
00:59:36I
00:59:38I
00:59:40I
00:59:42I
00:59:44I
00:59:46I
00:59:48I
00:59:50I
00:59:52I
00:59:54I
00:59:56I
00:59:58I
01:00:00I
01:00:02I
01:00:04I
01:00:06I
01:00:08I
01:00:10I
01:00:12I
01:00:14I
01:00:16I
01:00:18I
01:00:20I
01:00:22I
01:00:24I
01:00:26I
01:00:28I
01:00:30I
01:00:32I
01:00:34I
01:00:36I
01:00:38I
01:00:40I
01:00:42I
01:00:44I
01:00:46I
01:00:48I
01:00:50I
01:00:52I
01:00:54I
01:00:56I
01:00:58I
01:01:00I
01:01:02I
01:01:04I
01:01:06I
01:01:08I
01:01:10I
01:01:12I
01:01:14I
01:01:16I
01:01:18I
01:01:20I
01:01:22I
01:01:24I
01:01:26I
01:01:28I
01:01:30I
01:01:32I
01:01:34I
01:01:36I
01:01:38I
01:01:40I
01:01:42I
01:01:44I
01:01:46I
01:01:48I
01:01:50I
01:01:52I
01:01:54I
01:02:00I
01:02:02I
01:02:04I
01:02:06I
01:02:10I
01:02:12I
01:02:14I
01:02:16I
01:02:18I
01:02:20I
01:02:34I
01:02:36I
01:02:38I
01:02:40I
01:02:42I
01:02:44I
01:02:46I
01:02:48I
01:02:50I
01:02:52I
01:02:54I
01:02:56I
01:02:58I
01:03:00I
01:03:02I
01:03:04I
Recommended
1:08:17
|
Up next
1:44:20
19:03
1:31:31
1:11:49
1:31:40
1:08:19
1:58:00
1:10:48
1:20:45
21:29
1:41:17
56:07
22:29
1:46:36
1:17:04
22:00
9:02
34:43
10:15
4:38