How to get the count of distinct records. Please give me the
query?
Answer Posted / anilreddy
select count(distinct(columnname)) from tablename
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain steps of normalization?
Differentiate between SQL and ORACLE joins and write their syntax.
What is the use of keyword with encryption. Create a store procedure with encryption?
What are the different types of sub-queries?
Can a synonym name of a table be used instead of a table name in a select statement?
what are different types of backups available in sql server? : Sql server database administration
What are the different types of stored procedures?
Can primary key be null?
Where the sql logs gets stored? : sql server database administration
How much does sql server 2016 cost?
Explain an incremental backup?
What is the native system stored procedure to execute a command against all databases?
How to create sub reports?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Explain contrast amongst grouped and non-bunched records?