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
- 10200 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sanjeev
select ename,empno,count(column name) from table name
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
How many types of privileges are available in sql?
what are the advantages and disadvantages of views in a database? : Sql dba
How do sql databases work?
When is the update_statistics command used?
How to check if a column is nullable before setting to nullable?
What is rank dense_rank and partition in sql?
what is the difference between cluster and non cluster index? : Sql dba
What do you understand by exception handling in pl/sql?
what are the type of locks ? : Sql dba
How do you remove duplicates without using distinct in sql?
How many primary keys can a table have?
List the different type of joins?
what is bcp? When does it used? : Sql dba
What is record data type?
What is a constraint?
