select count(&a) from emp enter the column name at run time it will

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

8 Answers
11232 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / rolly

select count(&a) from emp

enter the column name at run time it will give the exact
count.

I have tested it. It works.

Is This Answer Correct ?

2 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I find duplicates in a single column in sql?

996

How to find 3rd highest salary of an employee from the employee table in sql?

1060

What can I use instead of union in sql?

947

What is trigger in sql and its types?

1041

Is sql microsoft?

1031

What is parallel hint?

1299

What is a join query?

937

What is benefit of creating memory optimized table?

955

what is the bond code in materialized view?

2980

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1057

What are the different datatypes available in PL/SQL?

1066

what is offset-fetch filter in tsql? : Transact sql

930

explain the advantages and disadvantages of stored procedure? : Sql dba

990

What is sqlexception in java?

966

What are different joins used in sql?

1042