Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
Answer Posted / jansi rani
SELECT EMPNAME,SAL FROM EMP GROUP BY EMPNAME,SAL
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Explain about remote stored procedure?
explain different types of joins? : Sql server database administration
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is the distinction amongst delete and truncate?
What are the approximate numeric data types?
What is the difference between seek predicate and predicate?
What is temporal table?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What are the default system databases in sql server 2000?
Why main is user defined function?
You want to use a perspective in an mdx query. How do you select the perspective?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is the sql profiler?