Asp.net Solution | sql tips

Here Reader, We are provide all question yhose asked in interview. you are read this blog and prepare for asp.net interview.

get only unique row and delete all duplicate row

delete from table1 where                
EmpID in(select cId from table1 group by cid having count(*) >1)
Posted by deepak at 11:22 pm No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: get only unique value in sql server

delete duplicate value in sql server

DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY column1,
column)
Posted by deepak at 11:21 pm No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: delete duplicate value
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Popular Posts

  • What is inheritance?
    Inheritance represents the relationship between two classes where one type derives functionality from a second type and then extends it ...
  • What is the difference between user and custom controls?
    User controls are easier to create whereas custom controls require extra effort. User controls are used when the layout is static wher...
  • Only Number validation in Textbox of ASP.NET Using Regular Expression validator
    Only numbers can enter into that Textbox We can use Regular expression validator for this: In the validation expression property ke...
  • difference between varchar and nvarchar datatype ?
    VARCHAR is an abbreviation for variable-length character string . It's a string of text characters that can be as large as the page siz...
  • What are functional and non-functional requirements?
     More Details :  Live Training in jaipur Functional requirements defines the behavior of a system whereas non-functional requirements...

Blog Archive

  • ▼  2014 (3)
    • ▼  April (2)
      • get only unique row and delete all duplicate row
      • delete duplicate value in sql server
    • ►  March (1)
  • ►  2013 (3)
    • ►  March (3)
  • ►  2012 (19)
    • ►  June (19)

About Me

deepak
View my complete profile
Simple theme. Powered by Blogger.