Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 my sql

Author  Topic 

sabari
Starting Member

1 Post

Posted - 2012-09-18 : 02:12:53
i have table like this....

Result
Sid SubjectCode Avg SEM
1 07CS42 34 1
1 07CS43 25 1
1 07CS44 34 1
2 07CS22 43 1
2 07CS23 52 1
2 07CS24 61 2
3 07CS32 70 3
3 07CS33 79 3
3 07CS34 88 3


if am writing query like where sem='1' it wil display the result automatically like



SID 07CS42 07CS43 07CS44
1 67 78 78


sabarisan

Abu-Dina
Posting Yak Master

206 Posts

Posted - 2012-09-18 : 04:43:06
This is SQL Server forum and your question needs further clarification.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-18 : 10:55:16
can you explain how you got those values? 67,78 etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -