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
- 8 Answers
- 10201 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
What are the various levels of constraints?
What is anonymous block in sql?
Is keyword pl sql?
How do I order columns in sql?
What is materialized view in sql?
What are the types of functions in sql?
How to select all records from the table?
How do you take the union of two tables in sql?
what is rdbms? : Sql dba
What is spool?
Is sqlexception checked or unchecked?
What are the different types of constraints?
tell me about various levels of constraint. : Sql dba
What are reports usually used for?
explain the difference between myisam static and myisam dynamic. : Sql dba
