munir tailor

munir tailor

  • 1.7k
  • 445
  • 10.4k

How to get different term result in different column in sql?

Jan 12 2019 7:30 AM
i want sasmahi means 6th term result
n salana means yearly result
i want to achieve something like this
 
salana 50 
salana 50
salana 50
salana 50 
sasmahi 50
sasmahi 50
sasmahi 50
sasmahi 50
 
i want in different columns
salana sashmahi
50            50 
50            50
50            50
50            50 
with subject and other fields. 
 

Answers (4)