select ename,empno,count(column name) from table name

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 / sanjeev

8 Answers
11593 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

Please Help Members By Posting Answers For Below Questions

What is dense_rank?

989

What are string functions in sql?

1306

What is latest version of sql?

1103

Why do we use subquery?

1080

Can a view be mutating? If yes, then how?

1088

what is a stored procedure? : Sql dba

1192

What is difference between nchar and nvarchar?

1103

What is the primary use of normalization?

1054

What is query optimization in sql?

1043

What is trigger in flip flop?

1063

Can we insert data in view?

1011

what are the difference between clustered and a non-clustered index? : Sql dba

1089

What is a left inner join?

1071

What do you understand by pl/sql packages?

1108

How do I edit a trigger in sql developer?

1054