��

��

��

��

��DB��(��)��

��

��A��A1 ��A1-1 ��

��A��A1 ��A1-2 ��

��A��A1 ��A1-3 ��

��A��A1 ��A1-4 ��

��A��A1 ��A1-5 ��

��A��A1 ��A1-6 ��

��A��A1 ��A1-7 ��

��A��A1 ��A1-8 ��

��A��A1 ��A1-9 ��

��A��A1 ��A��-10 ��

��A��A1 ��A1-11 ��

��A��A1 ��A1-12 ��

��A��A2 ��A2-1 ��

��A��A2 ��A2-2 ��

��B��B1 ��B1-1 ��

��B��B1 ��B1-2 ��

��B��B1 ��B1-3 ��

��B��B2 ��B2-1 ��

��B��B2 ��B2-1 ��

SQL��

��

��A��A1 ��A1-1 ��

��A��A1 ��A1-2 ��

��A��A1 ��A1-3 ��

��A��A1 ��A1-4 ��

��A��A1 ��A1-5 ��

��A��A1 ��A1-6 ��

��A��A1 ��A1-7 ��

��A��A1 ��A1-8 ��

��A��A1 ��A1-9 ��

��A��A1 ��A��-10 ��

��A��A2 ��A2-1 ��

��A��A2 ��A2-2 ��

��B��B1 ��B1-1 ��

��B��B1 ��B1-2 ��

��B��B1 ��B1-3 ��

��B��B2 ��B2-1 ��

��B��B2 ��B2-1 ��

��TOP��

��A��A1 ��A1-11 ��

��A��A1 ��A1-12 ��

��

�� info

�� Varchar

�� Varchar

�� Varchar

�� int

��

��

��>select * top 10 from info group by ��1,��2 order by ��;

��SQL��

��

��

��