2 תגובות

1. 

   guy sharabi ב06/04/2017 ב13:46

   	
   
   with T as(
   select NTILE(2) over(order by s_id) NT ,* from studentGrades
   )
   select s_grade from T
   where 
   s_id = (select MAX(s_id) from T where NT = 1 )
   
   

   השאר תגובה
2. 

   Adi Gutner ב13/08/2017 ב17:08

   
   select s_grade GRD
   from (
   select *,
   row_number() over (order by s_grade) rn
   from studentGrades) tbl
   where rn = (select ceiling(count(*)/2.0) from studentGrades)
   
   

   השאר תגובה