Count from table in database sql

Question

How can i count a specific ward in a table in database sql. Example, i have a table and i want to count how many times repeated ward "hello", can you help me please)

How does your table look? I'd be able to provide you with a functioning query if I have a rough idea how the table looks. — Thoby, Apr 19 '17 at 13:07

score 0 · Accepted Answer · answered Apr 19 '17 at 13:10

0

Lets say you have a target table ie tbl_test with a column i.e my_column, the query would look like this

SELECT COUNT(*) FROM tbl_test WHERE my_column = 'hello';

answered Apr 19 '17 at 13:10

Abel Masila

736
2
7
25

Can i search with no specific column in the table? – anasalim28 Apr 19 '17 at 13:18
For Ms Sql sever ,try this: [link](http://thesitedoctor.co.uk/blog/search-every-table-and-field-in-a-sql-server-database-updated). – Abel Masila Apr 19 '17 at 13:24

score 0 · Answer 2 · answered Apr 19 '17 at 13:11

0

If I understand your question it should look like this:

SELECT COUNT(Word), Country
FROM Customers
WHERE Word='hello'
GROUP BY Country;

https://www.w3schools.com/sql/sql_groupby.asp

answered Apr 19 '17 at 13:11

NoOorZ24

2,914
1
14
33

If you posted how your table looks I could write an example with your variables – NoOorZ24 Apr 19 '17 at 13:13
Maybe its what i want, i will try it. Thank you) – anasalim28 Apr 19 '17 at 13:20

score 0 · Answer 3 · answered Apr 19 '17 at 13:14

0

You can try select count(nameOfTheFieldWhenCanAppearHello)from table where nameOfTheFieldWhenCanAppearHello='Hello' group by nameOfTheFieldWhenCanAppearHello

answered Apr 19 '17 at 13:14

Carolina Gil

1
1

Count from table in database sql

3 Answers3