+ 2
Hello everyone. Is there no way of changing the ID column of the tables that have been joined using UNION to be unique
What I mean here is, instead of having 1,2,3,1,2,3 as the ID of the resulting table, you convert it to 1,2,3,4,5,6 and so on.....using a line of code.
4 ответов
+ 2
SELECT DISTINCT id
FROM table1, table2
WHERE condition
ORDER BY id ASC;
+ 1
Any more ways I can do this pls?
0
INSERT INTO Employees (ID, FirstName, LastName)
VALUES (5, 'john', 'philip');
please try this syntax
0
This will give you a new row