Besonderhede van voorbeeld: -3375607581936993533

English

Consider a modified Employee table such as the following: An example solution query could be as follows: SELECT F.EmployeeID, F.LastName, S.EmployeeID, S.LastName, F.Country FROM Employee F INNER JOIN Employee S ON F.Country = S.Country WHERE F.EmployeeID < S.EmployeeID ORDER BY F.EmployeeID, S.EmployeeID; Which results in the following table being generated.

Korean

다음과 같이 수정된 Employee 테이블이 있다고 하자: 상기 예의 해답 질의어는 다음과 같을 것이다 : SELECT F.EmployeeID, F.LastName, S.EmployeeID, S.LastName, F.Country FROM Employee F INNER JOIN Employee S ON F.Country = S.Country WHERE F.EmployeeID < S.EmployeeID ORDER BY F.EmployeeID, S.EmployeeID; 이것은 아래와 같이 생성된 테이블로 이어질 것이다.