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

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

How to list all user defined functions in the current database?

0 Answers  

How to override dml statements with triggers?

0 Answers  

where can you add custom error messages to sql server? : Sql server administration

0 Answers  

How can I check if a view exists in a sql server database?

0 Answers  

Do you know the cursor optimization tips?

0 Answers  

What is a trace frag?

0 Answers  

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

how to do partition in sqlserver

0 Answers   TCS,

Can we add our custom code in ssis?

0 Answers  

How to generate create table script on an existing table in ms sql server?

0 Answers