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 ответов

6 просмотров

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

1 день назад

Rafael Dias

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

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

0

1 день назад

Rafael Dias · Accepted Answer

Rafael Dias

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

0

3 дня назад

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

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

3 ответов

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