How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?
Answer Posted / virendra maurya
We can simply remove duplicate from table
1. Using CTE
2. Using Group by
3. Using Rank function
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Can you explain what are various ways to enhance the ssrs report?
What is the process of normalising?
explain different types of backups avaialabe in sql server? : Sql server database administration
Tell about MOM Tool(Microsoft Operator Manager)?
what is the system function to get current user's user id? : Sql server database administration
What is failover clustering overview?
How to change the password of a login name in ms sql server?
Can you explain powershell included in sql server 2008?
What is the difference between varchar and nvarchar?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
In what version of sql server were synonyms released?
What is subquery in sql?
what are user defined datatypes? : Sql server database administration
How to run sql server 2005 books online on your local system?