Thank you sir for wonderful explanations could please make the more video's on Windowing Clause like (function over the partitions),rank,dense rank,row_number ,rank,ntile,sum and average etc

ans of last question select emp_id , emp_name , emp_salary , dept_name , dept_location from employee inner join depatrment on employee.emp_deptid = depatrment.dept_id where dept_id in (select dept_id from depatrment where dept_location = 'New york')

Can i learn all the contents using php myadmin ?

Can you please help me

Hi sir when I am going to install I am facing the feature you are trying to use on network resources that is unavailable And next there mentioned enter a alternate path to a folder containing

Sir ye 1 hi project h ya 6 alag alag ?

mssql ke interview question ki ek series banana bhi

Excellent video

Nice

very informative

Bhai thanks yaaaaaar, ab thoda bohot dimag mai ghus raha hai, is video kp dekhne ke baad.

Can you make a video on oracle free database administration course?

select empID AS 'Employee ID' , empName AS 'Employee Name' , empSalary AS 'Employee Salary' , empJob AS 'Employee Job', empPhone AS 'Employee Phone' , deptId AS 'Department ID' from employee_info where deptId = (select departId from department_info where departLocation = 'newyork');

Sir your content is very good but audio quality is very poor

BEGIN DECLARE @Salary decimal; select @Salary =AVG(Salary) from Employees; select @Salary AS 'AVG.Salary'; If @Salary >80000 BEGIN PRINT 'AVERAGE salary is greater than 35000'; END ELSE IF @Salary>50000 BEGIN PRINT 'Average salary is between 50000 and 60000'; END ELSE IF @Salary >70000 BEGIN PRINT 'SALARY IS GRATER THAN AVERAGE'; END ELSE BEGIN PRINT 'salary is less than average'; END END is this correct?

I was doing the same way as you do but it is showing Ambiguous error what does it mean..

QUE-4 ---In SQL Server, to get the top N rows, you need to use OFFSET with FETCH. SELECT c.CustomerID, CONCAT(c.FirstName,' ',c.LastName),SUM(o.TotalAmount) AS TotalSpent FROM Customers c join Orders o ON c.CustomerID = o.CustomerID GROUP BY c.CustomerID, CONCAT(c.FirstName,' ',c.LastName) ORDER BY TotalSpent DESC OFFSET 0 ROWS FETCH FIRST 5 ROW ONLY;

sir agar keval second or third salary print karana ho toh kya command hoga

permission denied error message coming while i am executing create database query

@21:31 in this way how doe the inserted data come from magic inserted table as u mention insert data ony avilable in insert magic table

Kindly provide videos on window function ur way teaching is extraordinary sir

Hi sir, below query is correct-- --Query 5: Retrieve the most popular product category SELECT Top 1 CategoryName,c.Categoryid, sum(quanity) as totalsales from OrderItems as o; join Products as P on o.ProductID=p.ProductID join Categories as c on p.CategoryID=c.CategoryID group by c.Categoryid,categoryname order by totalsales desc

sir leetcod ke solution bhi btaoye

sir can you make videos on AWS and ML

Voice is not clear

SELECT E.EMP_NAME, E.EMP_SALARY FROM EMPLOYEE E LEFT JOIN DEPARTMENT D ON E.EMP_DEPTID=D.DEPT_ID WHERE D.DEPT_LOCATION = 'NEW YORK';

SELECT * FROM EMPLOYEE WHERE EMP_DEPTID = (SELECT DEPT_ID FROM DEPARTMENT WHERE DEPT_LOCATION = 'NEW YORK' );

SELECT EMP_ID, EMP_NAME, EMP_SALARY, EMP_DEPID,DEPT_NAME,DEPT_LOCATION FROM (SELECT * FROM EMPLOYEE E LEFT JOIN DEPARTMENT D ON E.EMP_DEPID = D.DEPT_ID WHERE D.DEPT_LOCATION = 'NEW YORK') t; used subquery, join and aliase

I cannot download it on Mac, is there any alternatives?

I would request you to kindly make video on long complex sql query for power bi or tableau requirement ..

Excellent ...I really appreciate the way u explain in simple manner ...I have watch many videos to understand this , but finally my conclusion has been solved with your way of explaining ..I can say no will beat on KZbin for this ...really appreciated and thank you ...entire series was clearly capture apple to apple ..

C lanvej

Please share data file or CSV file

Please send data file

Hi sir

I ❤ like your vedio apka samjany ka andaz bohat acha ha bhai

hii @Ishwar i tried order by clause in my string values and it doesn't work on string values

Tnx ❤❤❤

15:03 category id ko references nhi kiya apne

SIR IN QUERY 37 CAN WE DO LIKE THIS ? SELECT * FROM vw_RecentOrders ORDER BY OrderDate DESC;

I like your working bro ❤

i see a distorted screen in this video is that same for others?

Bhai, thanks a lot, I was able to solve one SQL problem on hackerrank because of this video.. The blunder on hackerrank on ms SQL ssms Data type Money ❤

Sir very nicely explained. One request- please make tutorial on SSIS.!

sir question 4 (select c.customerID, c.FirstName, c.Lastname, sum(o.totalamount) as Totalamount from customers c join orders o on c.customerID = o.customerID group by c. firstName, c.Lastname order by Total amount desc LIMIT 5:) this is correct query for this question sir

Sir is this project is good for resume?

Can I make this project in snowflake

Video link

isko modify kese ker sakte hai

can you speak loudly, then we can understand the word which you are saying. your voice is very low.