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
- 11230 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
what is the stuff function and how does it differ from the replace function? : Sql dba
Why do we use function in pl sql?
What is the use of pl/sql table?
What are the different ddl commands in sql?
How to get each name only once from an employee table?
how many triggers are allowed in mysql table? : Sql dba
How to handle bulk data?
Is sql scripting language?
What is clustered index in sql?
what is the syntax used for partition in tsql? : Transact sql
Explain how exception handling is done in advance pl/sql?
Can a table contain multiple foreign key’s?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what is the difference between where clause and having clause? : Sql dba
What is cte sql?
