Sign in
Microsoft.com
United States (English)Drop down arrow
Australia (English)Brasil (Português)Česko (Čeština)Danmark (Dansk)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)Magyarország (Magyar)Nederland (Nederlands)Polska (Polski)România (Română)Singapore (English)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中国 (中文)台灣 (中文)日本 (日本語)香港特別行政區 (中文)
 
 
 
Microsoft
 
 
Home
 
 
 
 
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Search related threads

RRS feed

  • Remove From My Forums

Asked by:

 locked
Counting columns based on a condition in sql server 2005 RRS feed

Archived Forums
 > 
SQL Database
  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,
    I have a table
    whose coluns are
    id,
    marks1,
    marks2,
    marks3,
    ...
    ..
    ..
    marks10

    i want a sql query to get the number of columns where marks='A' for each record?
    please help me it's very urgent.
    Friday, December 18, 2009 12:54 PM
 
© 2023 Microsoft Corporation. All rights reserved.
Terms of Use
|
Trademarks
|
Privacy Statement