Thursday 19 October 2023

How to delete duplicate records from a SQL data table

 introduction

How to delete duplicate records from a SQL data table using CTE (common table expression). Specifies a temporary named result set, known as a common table expression (CTE).

Syntax

  1. WITH table_nameCTE AS  
  2. (  
  3.    SELECT*, ROW_NUMBER() over (PARTITION BY ID ORDER BY ID) as < alias_name >  
  4.    FROM table_name  
  5. )  
  6. DELETE FROM table_nameCTE WHERE alias_name >1  

Step 1

Open SQL Server 2014 or your choice. Create table with name Employees.
  1. create table Employees  
  2. (  
  3.    ID int,  
  4.    Name nvarchar(50),  
  5.    Gender char(10),  
  6.    Salary int  
  7. )  

Step 2

Insert some duplicate record. Below is sample record.
  1. insert into Employees values(1,'Farhan Ahmed','Male',60000)  
  2. insert into Employees values(5,'Monika','Female',25000)  
  3. insert into Employees values(2,'Abdul Raheem','Male',30000)  
  4. insert into Employees values(4,'Rahul Sharma','Male',60000)  
  5. insert into Employees values(1,'Farhan Ahmed','Male',60000)  
  6. insert into Employees values(2,'Abdul Raheem','Male',30000)  
  7. insert into Employees values(5,'Monika','Female',25000)  
  8. insert into Employees values(4,'Rahul Sharma','Male',60000)  
  9. insert into Employees values(1,'Farhan Ahmed','Male',60000)  
  10. insert into Employees values(3,'Priya','Female',20000)  
  11. insert into Employees values(5,'Monika','Female',25000)  
  12. insert into Employees values(4,'Rahul Sharma','Male',60000)  
  13. insert into Employees values(5,'Monika','Female',25000)  
  14. insert into Employees values(2,'Abdul Raheem','Male',30000)  
  15. insert into Employees values(1,'Farhan Ahmed','Male',60000)  
  16. insert into Employees values(4,'Rahul Sharma','Male',60000)  

Step 3

Write CTE (Common table expression) and partition records.
  1. WITH EmployeesCTE as  
  2. (  
  3.    SELECT*, ROW_NUMBER() over (PARTITION BY ID ORDER BY ID) as RowNumber  
  4.    FROM Employees  
  5. )  
  6. SELECT * FROM EmployeesCTE  
Delete Duplicate Record From SQL Database Using CTE
 
Step 4
 
Write query for delete duplicate record with CTE (common table expression).
  1. WITH EmployeesCTE as  
  2. (  
  3.    SELECT*, ROW_NUMBER() over (PARTITION BY ID ORDER BY ID) as RowNumber  
  4.    FROM Employees  
  5. )  
  6. DELETE FROM EmployeesCTE WHERE RowNumber>1  
  7.   
  8. SELECT * FROM Employees  
Delete Duplicate Record From SQL Database Using CTE


Source : https://www.c-sharpcorner.com/blogs/delete-duplicate-record-from-sql-data-table-using-cte

Tuesday 27 July 2021

how to run C Graphics Program in UBUNTU


                 how to Include gcc <graphics.h>?
ans
  This post is about how you can run graphics program in Ubuntu platform.

Steps:


Step:1
Make sure that you have basic compilers installed. For this run the command:
     sudo apt-get install build-essential

Thursday 19 November 2020

PYMONGO INSTALLATION STEPS

 PYMONGO INSTALLATION STEPS :

1. Copy & paste pymongo-2.7.1.tar.gz in Home Directory and extract it. 2. Open terminal

>cd pymongo-2.7.1

>sudo python setup.py install

installation complete.

PYMONGO SUPPORT TOOLS INSTALLATION STEPS :

1. Copy & paste pypa-setuptools-9616be97e6a7.tar.gz in Home Directory and extract it.

2. Open terminal

>cd pypa-setuptools-9616be97e6a7

>sudo python setup.py install

installation complete.

Copy & paste jdk-7u25-linux-i586.tar.gz in home folder and extract it.

Copy & paste eclipse-jee-luna-R-linux-gtk.tar.gz in home folder & extract it. Copy & paste apache-tomcat-7.0.55.tar.gz in home folder and extract it. Copy & paste mysql-connector-java-5.1.18-bin.jar in home folder, apache-tomcat-7.0.55/bin, apache-tomcat-7.0.55/lib.

Copy & paste mongo-java-driver-2.12.2.jar in home folder

PYTHON INSTALLATION STEPS

 PYTHON INSTALLATION STEPS :

1. Copy Python-3.3.2.tar.bz2 and Django-1.5.2.tar.gz & paste both in Home Directory and extract them.

2. Open terminal

>cd Django-1.5.2

>sudo python setup.py install

  

 installation complete.

MONGODB INSTALLATION STEPS

 MONGODB INSTALLATION STEPS :

1. Copy & paste mongodb-linux-i686-2.4.6.tgz and extract it in home folder and create one folder in mongodb-linux-i686-2.4.6 \bin folder (ex. snjb) >sudo mkdir /data

>sudo mkdir /data/db

>sudo chmod 777 /data/*

>cd ~/mongodb-linux-i686-2.4.6/bin >./mongod --dbpath snjb

right click and open new terminal and give following command >./mongo

installation complete.

Friday 13 November 2020

Difference between Intel Core i3, i5 and i7

Difference between Intel Core i3, i5 and i7
To conclude in a statement, Core i7s are better than Core i5s, and Core i5s are better than Core i3s. The main reason here being performance. In general, Core i3 chips are found in budget PCs and low-end laptops. For a normal user who does browsing and watching videos, Core i3 works just fine. Core i3s have a low Cache size.
The mainstream or mid-range systems usually  have i5. Systems with Core i5 are good for a moderate user and light gamer.

Wednesday 13 May 2020

Text Editor Python Using tkinter

Text Editor using python




from tkinter import *
from tkinter.filedialog import *
from tkinter.messagebox import *
from tkinter.font import Font
from tkinter.scrolledtext import *
import file_menu
import edit_menu
import format_menu
import help_menu

root = Tk()

root.title("Text Editor-Untiltled")
root.geometry("300x250+300+300")
root.minsize(width=400, height=400)

text = ScrolledText(root, state='normal', height=400, width=400, wrap='word', pady=2, padx=3, undo=True)
text.pack(fill=Y, expand=1)
text.focus_set()

menubar = Menu(root)

file_menu.main(root, text, menubar)
edit_menu.main(root, text, menubar)
format_menu.main(root, text, menubar)
help_menu.main(root, text, menubar)
root.mainloop()





How to delete duplicate records from a SQL data table

  introduction How to delete duplicate records from a SQL data table using CTE (common table expression). Specifies a temporary named result...