How to get the count of distinct records. Please give me the
query?
Answer Posted / soumya
select distinct (columnname) from tablename
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is updatable resultset?
Can you get second highest salary from the table?
How do I partition a table in sql server?
What is the difference between resultset and resultsetmetadata?
What is exporting and importing utility?
can we have a nested transaction? : Sql server database administration
How to delete duplicate rows?
How do users use Report Builder with SQL Server data sources?
What command is used to rename the database?
What is the difference between the application object and session object?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is the architecture of ms sql reporting service?
which backup strategy you are following at ur company
Write a sql query to display the current date?
How can I add Reporting Services reports to my application?