select count(column_name) from table_name; if u want to count number of

i want count no of values in a column i.e
enam eempno phoneno
x 1 (98765,09887,096561,87964579,156678,678900876)
that means if i select phone no from table i want to get
total count of phone numbers i.e 6

Question Posted / venkat

8 Answers
11030 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / venkat

select count(column_name) from table_name;

if u want to count number of phone numbers then use below
from emp table

select count(phno) from emp;

Is This Answer Correct ?

3 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is join same as left join?

979

How to make a copy values from one column to another in sql?

985

Does mysql_real_escape_string prevent sql injection?

911

Can we use ddl statements in stored procedure?

1097

How many commands are in sql?

1003

What are the types of optimization?

889

What is sql injection owasp?

1001

Why is sql*loader direct path so fast?

1054

What is sql comments?

1038

What does the argument [or replace] do?

1017

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1095

What is sap sql anywhere?

975

Is sql developer case sensitive?

945

How to select random rows from a table?

1023

Explain what is a database?

1040