Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / ajmal khan

Answer Posted / ajmal khan

select count(column_name) from table_name;

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the syntax used for partition in tsql? : Transact sql

729

How do you use join?

703

What is the primary key?

700

describe transaction-safe table types in mysql : sql dba

702

How to run pl sql program in mysql?

681




Where do we use pl sql?

724

what is rollback? : Sql dba

758

differentiate between float and double. : Sql dba

763

what is blob? : Sql dba

742

How do you create a unique index?

776

Define SQL and state the differences between SQL and other conventional programming Languages?

871

What is a sql*loader control file?

790

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

728

What is the source code of a program?

709

Why primary key is required?

722