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
11023 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 full join in sql?

937

Can we join more than 2 tables in sql?

945

what is uncommittable transactions? : Transact sql

953

What is time based sql injection?

900

What is the usage of distinct keyword?

1017

What are field types?

939

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1785

Can I learn sql in a week?

1004

What is the difference between partition and index?

923

How can we store rows in PL/SQL using array?

1159

What is the execution plan in sql?

972

Can a table have no primary key?

1008

How do I turn a list into a table?

905

What are all the common sql functions?

969

What is sql in java?

1025