Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 13539 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / madhavi.bandreddi
select count(*) from (select distinct * from tablename)as
dummytable
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is merge join?
Explain the categories of stored procedure?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is "scheduled jobs" or "scheduled tasks"?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
can an order by clause be used in a creation of a view?
Can we write ddl in trigger?
What is a filestream?
What is multi-statement table-value user-defined function?
Do I need a report server to run reports in my application?
Explain transaction server isolation?
What are “lost updates”?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What are the steps to process a single select statement?
How do I trace a query in sql server?
