select count(column_name) from table

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 / ajmal khan

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

Answer Posted / ajmal khan

select count(column_name) from table_name;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you define a foreign key?

1003

Explain the components of sql?

1061

What are triggers and its uses?

1046

What is the difference between partitioning and sharding?

1008

What is assignment operator in pl sql?

1035

how many ways we can we find the current date using mysql? : Sql dba

1099

How do I start sql profiler?

993

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1222

How do I enable sql encryption?

1033

What is posting?

1039

What is a stored procedure in sql with example?

1131

What type of database is cloud sql?

1101

What are the types of index in sql?

1069

Why does sql need a server?

1040

What is pl sql in oracle?

1042