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
- 13272 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
How do I know if localdb is running?
What is default constraint?
What are the triggers in sql?
how we use window authentication connection with sql server.?
List down some advantages of sql stored procedure?
Explain what is the difference between a local and a global temporary table?
What does <> symbol mean?
What is page in sql server?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is difference in performance between insert top (n) into table and using top with insert?
Explain go command in sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is rs.exe utility?
How to send a ssrs report from ssis?
Is it possible to create trigger on views?
