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 Boxing/Unboxing?
     More Details :  Live Training in jaipur Boxing is used to convert value types to object. E.g. int x = 1; object obj = x ; Unb...
  • what is abstract class ?
     More Details :  Live Training in jaipur Abstract class is a class that can not be instantiated, it exists extensively for inheritance ...
  • What are events and delegates?
    An event is a message sent by a control to notify the occurrence of an action. However it is not known which object receives the event. F...
  • Check UserName Email Availability In Asp.Net Ajax
    For this create a table Users in sql server database with ID,Uname,emlAddress columns  and add some records in it. Add ScriptManag...
  • 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...
  • Example DataAdapter : use DataAdapter in asp.net
    DataAdapter Example :  This is a example of  dataadapter. < %@ Page  Language = "C#"  % >    < %@ Import  Namesp...
  • Difference between SqlDataAdapter or sqlDataReader ?
     More Details :  Live Training in jaipur Ques.1 :  Difference between SqlDataAdapter or sqlDataReader ? Ans  :      1.A DataReader w...
  • What is business logic?
    It is the functionality which handles the exchange of information between database and a user interface.
  • 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...

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.