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
11233 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

What is procedure in pl sql?

1022

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2150

What is natural join in sql?

959

What are the methods of filing?

918

Explain the commit statement.

1138

Difference between truncate, delete and drop commands?

1063

How does index help in query performance?

1013

what is online transaction processing (oltp)? : Sql dba

977

What is forward declaration in pl sql?

1055

What is insert command in sql?

1105

What is schema in sql?

927

What is scalar and vector?

986

what is the difference between delete and truncate commands? : Sql dba

1043

What is integrity in sql?

1022

Can we have two clustered index on a table?

1009