Answer / kanika

this will also work

select count(distinct columnname) from table

Answer / name

select count(distinct columnname) from table ,this is correct as i checked the query

Answer / anusha

SELECT COUNT(*)FROM(SELECT DISTINCT columnname FROM
tblname)

Answer / pradyumna

select distinct colname,count(colname) from tbl group by
colname

Answer / madhavi.bandreddi

select count(*) from (select distinct * from tablename)as
dummytable

Answer / gouri

SELECT count(*) FROM
(SELECT distinct ngcode FROM donation )d

Answer / anilreddy

select count(distinct(columnname)) from tablename

Answer / soumya

select distinct (columnname) from tablename

what is the disadvantage of SQL Loder?

1 Answers   TCS,

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

How do I find the size of a sql server database?

0 Answers  

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

Does sql server 2016 have ssms?

0 Answers  

What is partition index in sql server?

0 Answers  

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

Do you know what is sql service broker?

0 Answers  

What is difference statement and preparedstatement?

0 Answers  

How efficient you are in oracle and SQL server?

0 Answers   CGI,