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 an inner join?

0 Answers  

What is the correct order of the logical query processing phases?

0 Answers  

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

How would you use user_constraints table in DB?

0 Answers   Wipro,

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

Can foreign key be duplicate?

0 Answers  

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

Explain primary key in sql server?

0 Answers  

What is the impact on other user sessions when creating indexes?

0 Answers  

What is Trace flag?

1 Answers   Wipro,

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,