Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11367 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 is the difference between partitioning and sharding?
What is left inner join in sql?
What are the two types of cursors in pl sql?
Can we insert data into materialized view?
what is the difference between char_length and length? : Sql dba
What are crud methods?
What is flag in sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How many types of tables are there?
What problem one might face while writing log information to a data-base table in pl/sql?
How to convert comma separated string to array in pl/sql?
What is the maximum number of rows in sql table?
How long will it take to learn pl sql?
What is null in pl/sql?
How is use pl and sql?
