Can anyone exlain this query? SELECT Employees.LastName, COUNT(Orders.OrderID) AS NumberOfOrders FROM (Orders INNER

Question

Can anyone exlain this query? SELECT Employees.LastName, COUNT(Orders.OrderID) AS NumberOfOrders FROM (Orders INNER

JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID)
GROUP BY LastName
HAVING COUNT(Orders.OrderID) > 10;

this part-
(Orders
INNER JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID)

is this correct syntax? i have seen it for first time

#english #programming #sql

0

27.06.2024

3 ответов

32 просмотра

Abhijeet Автор вопроса

Rafael Dias
This is the INNER JOIN. This and LEFT JOIN are the...

But when we write inner join the syntax will be- Select * from table1 Inner join table2 On condition But in the above one, the select is omited, is that correct syntax

0

29.06.2024

Rafael Dias

Abhijeet
But when we write inner join the syntax will be- ...

https://stackoverflow.com/questions/67544632/parenthesis-for-join-clause

0

29.06.2024

Rafael Dias · Accepted Answer

Rafael Dias

This is the INNER JOIN. This and LEFT JOIN are the most commonly used types of JOIN.

0

27.06.2024

169 похожих чатов

Can anyone exlain this query? SELECT Employees.LastName, COUNT(Orders.OrderID) AS NumberOfOrders FROM (Orders INNER

3 ответов

Похожие вопросы