select more than one column with count func

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 Administration

select more than one column with count func

Author

Topic

younas02
Starting Member

28 Posts

Posted - 2012-06-28 : 10:03:01

hi.
i want to select rows with count function.
i want to select name, fathername, count(marks) with a condition like percentage >50, count(status) with a condition like pass or fail
is it possible ?
plzz help me

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2012-06-28 : 10:16:32

Dude - please don't cross post.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176267
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176266
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176265
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176263
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176262
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=176261

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources