In first question solution it is deleting all the duplicate records, as per me it should be keep 1 record in table and need to delete other one which is duplicate. What your thought?
on Q3, I am confused that from the 'select count...' we can only get get the counts and for sure it can be compared with 5, but why can we use the count to filter e1 as should be no such 'count' columns in e1, right?
Hi. For question 6, I couldn't understand why 3-1 is used to get 3rd highest salary. I mean, how can 3-1 give us 3rd highest salary. Could you please clear up my doubts? Thanks a ton for these videos.
If n=3rd highest salary from employee---------- select * from ( select e_name ,e_salary, dense_rank() over(order by e_salary desc) as RN from employee ) as X where RN=3 give same o/p
Q10 select d.dname, e ename, e salary from dept d inner join emp e on d.deptno=e.deptno Where (e.deptno, e salary) IN (select e2.deptno, MAX( e2.salary) from emp e2 group by e2.deptno); It not working throw an error An expression of non-boolean type specified in a context where a condition is expected, near ','
Hello Swapnjeet. I have tried but it showing me error while creating the emp table. so what should i do? And error is-Msg 102, Level 15, State 1, Line 9 Incorrect syntax near ','.
thanks boss, please make more video on SQL , deeply explain joins,subqueries,store procedure . thanks well done
As soon as possible
Tq
Thanks i've prepared my interview test with your video. am so greatful for you to provide such a content. i wish i could have you as a mentor.
you are a great mentor - i am continuously learning a lot from your tutorial videos. Thank you so much !!!
Glad you like them!
Thanks for your effort and creating content like this to help the data community, really appreciated your help
great lots of lv from sri lanka
Can you share with us the query for REGION WISE SALES , TOP 5 CATEGORY WISE SALES, COUNTRY WISE SALES etc im bit confused by using group by functions
man you doing great work for us !!! god bless you
You're really Awesome!!
In first question solution it is deleting all the duplicate records, as per me it should be keep 1 record in table and need to delete other one which is duplicate. What your thought?
I agree with you. To solve this Question Rank Function is Better option.
Row_Number also works
Row_Number also works
on Q3, I am confused that from the 'select count...' we can only get get the counts and for sure it can be compared with 5, but why can we use the count to filter e1 as should be no such 'count' columns in e1, right?
Hi. For question 6, I couldn't understand why 3-1 is used to get 3rd highest salary. I mean, how can 3-1 give us 3rd highest salary. Could you please clear up my doubts? Thanks a ton for these videos.
Sir, I tried running it and it is showing error (An expression of non-boolean type specified in a context where a condition is expected, near ','.)
Please make videos on advance SQL required power bi to create data model
Sure
If n=3rd highest salary from employee---------- select * from ( select e_name ,e_salary, dense_rank() over(order by e_salary desc) as RN from employee ) as X where RN=3
give same o/p
Yes this works, as i said there are multiple ways to achieve it
Which one better career wise software testing or power BI..give me suggestion
In wich you are good enough or having interest... ask yourself
In my sql sutdio management limit clause can't use instead of what we will use sir?
I think Top
Hi, can we get sample data which you used to explain in the video
You can fire the create table query to get data, query dox available in description box
Is this question for fresher or experienced person ?
Start from 1:21
Q10 select d.dname, e ename, e salary from dept d inner join emp e on d.deptno=e.deptno
Where (e.deptno, e salary) IN (select e2.deptno, MAX( e2.salary) from emp e2 group by e2.deptno);
It not working throw an error
An expression of non-boolean type specified in a context where a condition is expected, near ','
Hi,I found error 1630 function count does not exist error please help me I fresher
IN QUESTION 10 WHY R&D RETURNS TWO TIMES
Hello Swapnjeet. I have tried but it showing me error while creating the emp table. so what should i do?
And error is-Msg 102, Level 15, State 1, Line 9
Incorrect syntax near ','.
You are missing a comma somewhere
salary FLOAT, -- Change from DOUBLE to FLOAT
make this change in the creation script for emp table
Thanks its run@@aishwaryapattnaik3082