Just a Web Code Solution
How to delete duplicites from table using sql ?
60
SQL
0
By 7 years ago
The power of the user (%)
0
table1
id customer_number
1 222
2 333
3 222
delete from table1 where id not in
(select min(id) from table1 group by customer_number
By 7 years ago
The power of the user (%)
The most helpful SQL solutions
how to execute select into using sql ?SQL
Click to see more ...
621
53
convert string to date sqlSQL
Click to see more ...
530
42
How to get the last record from table using sql ?SQL
Click to see more ...
456
33
create table sqlSQL
Click to see more ...
229
23
How use like using sql ?SQL
Click to see more ...
307
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
200
21
rows to columns sqlSQL
Click to see more ...
156
17
insert new column into table sqlSQL
Click to see more ...
155
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
166
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
117
11
- Related solutions:
- delete table from databse sql
96 1 - How to delete all records from table using sql ?
66 3 - How to delete record from table using sql ?
126 0 -
Vote
0
- Latest solutions:
- create table sql
229 23 - insert new column into table sql
155 16 - rename column sql
114 3 - convert string to date sql
530 42 - get date from datetime sql
84 1 - get part of a string sql
78 0 - select year from datetime sql
114 1 - create table from select sql
137 3 - rows to columns sql
156 17 - delete table from databse sql
96 1 - Helpful solutions:
- how to execute select into using sql ?
621 53 - convert string to date sql
530 42 - How to get the last record from table using sql ?
456 33 - create table sql
229 23 - How use like using sql ?
307 22 - How to get the last 10 records using mysql ?
200 21 - rows to columns sql
156 17 - insert new column into table sql
155 16 - How to convert the values to lowercase using sql ?
166 13 - How to change a negative number to positive using sql ?
117 11
SQL
Would you like to receive an e-mail notification when new SQL solution is created?