mardi 4 août 2015

Sql Order by Student Grade No

I want to order my data,i have following data.

Below is my Data

  • 1
  • 1+
  • 1-
  • 2
  • 2+
  • 2-
  • 3
  • 3+
  • 3-
  • 4
  • 4+
  • 4-

I want to order Like this

  • 1+
  • 1
  • 1-
  • 2+
  • 2
  • 2-
  • 3+
  • 3
  • 3-
  • 4+
  • 4
  • 4-

I tried this

select * from RatingGrade where ScoreCardID=1   order by GradeNo



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire