select a row with more than 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

SQL Server 2005 Forums

Transact-SQL (2005)

select a row with more than count func

Author

Topic

younas02
Starting Member

28 Posts

Posted - 2012-06-28 : 10:05:18

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:11

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