Hello sir, I am watching all the videos in this playlist from the beginning. your explanation is very clear. Got a doubt while watching this video, while grouping by what should be the parameter to chose the columns? in this video you have chosen empno, empname and deptno under group by condition, can you please say why is that so?
Hello Sir, Can we use row_number() Over ( partition by emp_id) ?? Please check if i have written correctly ? ps: (Not executed query) ...,...................................................... Delete from ( select emp_id, emp_name,emp_salary, Row_Number() Over ( partition by emp_id) as rn) a where rn> 1;
Please watch all the SQL series playlist , I highly recommend you to watch all the videos , I have tried to cover in sequence so you must watch them in sequence to have in depth knowledge , for now for case you can watch this from the SQL series playlist th-cam.com/video/5EbEBhKAI40/w-d-xo.html I have also cover the case statement in previous sessions so you please watch entire series to gain a holistic knowledge
Hello sir.....apart from removing duplicates how to select records other than duplicates,can u tell me the query For eg: 1 2 2 3 4 4 From above table I want only 1 and 3 records, o/p is 1 3 How will I get this??? Please share video about this type of some interview questions..?
Tons of thanks no words to say you are explaining each and every topic so in-depth with simple way.
very good explanation sir, thank you for helping us all.
Hi Sir, how to remove duplicate with certain conditions? like I need to delete 4 records out of 5 from target having name=error.
th-cam.com/video/p10pyHsslok/w-d-xo.html
Please watch this video
Hello sir, I am watching all the videos in this playlist from the beginning. your explanation is very clear. Got a doubt while watching this video, while grouping by what should be the parameter to chose the columns? in this video you have chosen empno, empname and deptno under group by condition, can you please say why is that so?
Hello Sir, Can we use row_number() Over ( partition by emp_id) ?? Please check if i have written correctly ?
ps: (Not executed query)
...,......................................................
Delete from (
select emp_id, emp_name,emp_salary,
Row_Number() Over ( partition by emp_id) as rn) a where rn> 1;
Can you please tell me what is Decode and case
Please watch all the SQL series playlist , I highly recommend you to watch all the videos , I have tried to cover in sequence so you must watch them in sequence to have in depth knowledge , for now for case you can watch this from the SQL series playlist
th-cam.com/video/5EbEBhKAI40/w-d-xo.html
I have also cover the case statement in previous sessions so you please watch entire series to gain a holistic knowledge
Excellent
THANK YOU SO MUCH SIR
SO GOOD VIDEO
Sir thank you so much
Hiii sir
How to find out duplicates
We have 100 columns in the table. I want duplicates with 100 column names
Hello sir.....apart from removing duplicates how to select records other than duplicates,can u tell me the query
For eg: 1
2
2
3
4
4
From above table I want only 1 and 3 records, o/p is 1
3
How will I get this??? Please share video about this type of some interview questions..?
It's simple , instead of having count(*) >1 , just use m having count(*)=1 in the same query which is used to find duplicate