Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14 Answers
- 22174 Views
- I also Faced
- E-Mail Answers
Answer Posted / v.krishnakumar
using the keyword distinct we can avoid the duplicate value
in our table,(ex) SELECT DISTINCT empname FROM Employee
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What does asynchronous call backs means?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
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., }
Explain nested join?
What are the different types of lock modes in sql server 2000?
What is a group function explain with an example?
Explain about thread and memory management process of SQL?
What is a cache in ssrs?
Is oracle faster than sql server?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Which are the new data types introduced in sql server 2008?
What is database architecture? : SQL Server Architecture
What are transactions and its controls?
What will be the maximum number of indexes per table?
