How to get the count of distinct records. Please give me the
query?
- 8 Answers
- 11404 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / anilreddy
select count(distinct(columnname)) from tablename
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is a primary key unique?
Can another user execute your local temporary stored procedures?
What is attribute hierarchy? : sql server analysis services, ssas
What is shrink log file?
List the ways in which dynamic sql can be executed?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Can truncate be rolled back?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What are the steps to insert a table?
What is postgresql server?
What are the characteristics of modern DBMS?
How to encrypt data between dialogs?
How to retrieve error messages using odbc_errormsg()?
In what sequence sql statement is processed?
What are the components of sql server service broker?
