fuadhamidov
Programmer
hi
i need to get data by using order by clause. i use datapart( yyyy, .... ). it gives year. it is OK , but i need ten year semester. for example i want to group peaple for their born year :
1993 - 2002
1983 - 1992 etc.
is there any easy way in ms sql.
i need to get data by using order by clause. i use datapart( yyyy, .... ). it gives year. it is OK , but i need ten year semester. for example i want to group peaple for their born year :
1993 - 2002
1983 - 1992 etc.
is there any easy way in ms sql.