SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 my sql		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sabari
Starting Member

India
1 Posts
Posted - 09/18/2012 :  02:12:53  Show Profile  Reply with Quote
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

United Kingdom
199 Posts
Posted - 09/18/2012 :  04:43:06  Show Profile  Reply with Quote
This is SQL Server forum and your question needs further clarification.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47023 Posts
Posted - 09/18/2012 :  10:55:16  Show Profile  Reply with Quote
can you explain how you got those values? 67,78 etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000