2 תגובות

1. 

   guy sharabi ב04/04/2017 ב17:18

   	
   
   select S1.class , S1.first_name , S2.first_name last_name
   from students S1 
   join students S2 on S1.class = S2.class and S1.first_name >S2.first_name
   
   

   השאר תגובה
2. 

   mor balas ב21/08/2017 ב00:00

   פתרון כללי יותר להזחה במספר שורות משתנה-

   
   WITH "NAMES-CTE" AS  
      (  
      SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) RN ,  
             Names.first_name,
             Names.last_name  
      FROM dbo.Names  
      )
   
   SELECT S1.first_name , S2.first_name AS last_name 
   FROM "NAMES-CTE" S1 JOIN "NAMES-CTE" S2  
   ON S1.RN + (SELECT COUNT(*) FROM dbo.Names)/2  = S2.RN
   
   

   השאר תגובה