sql count column data, help

Question

0.00/5 (No votes)

See more:

hello, 1st of all i would like to appologise that i can't speak proper english..
im trying to make a sql querry
to count 2 different data from a column...

for an example..

table's name: table
column name ItemToCount (int)
in ItemToCount got 2 rows, first one is 3 and another one is 4...

this is my command :

SQL

select count(*) as NewItemToCount from table where ItemToCount = 3 and ItemToCount = 4

besides that i also try on this command even i know it won't work because im using integer but not string or character

SQL

select count(*) as NewItemToCount from table where ItemToCount = '3' and ItemToCount = '4'

but the result i get is
NewItemToCount = 0

anyone can correct my command so that i can get 2 for my NewItemToCount

Posted 14-Mar-14 2:15am

arnoldxx

Add a Solution

2 solutions

Solution 2

try this

select count(*) as NewItemToCount from table where (ItemToCount = 3 or ItemToCount = 4)

Posted 14-Mar-14 2:24am

Chandra Mohan N

Updated 14-Mar-14 2:25am

v3

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

King Fisher · Accepted Answer · 2014-03-14T02:21:00

Solution 1

if you use this

SQL

select count(*) as NewItemToCount from table where ItemToCount = 3 and   ItemToCount = 4

it will return only 0

SQL

select count(*) as NewItemToCount from table where ItemToCount = 3 or ItemToCount = 4

Posted 14-Mar-14 2:21am

King Fisher

Comments

arnoldxx 14-Mar-14 8:25am

Thx bro.. Its work :D

King Fisher 14-Mar-14 8:26am

:)