SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Tablename ( ColA VARCHAR(512), ColB VARCHAR(512), ColC VARCHAR(512) ); INSERT INTO Tablename (ColA, ColB, ColC) VALUES ('A', '100', 'a'), ('A', '150', 'b'), ('B', '100', 'c'), ('B', '100', 'd'), ('B', '120', 'e'), ('C', '200', 'f'), ('C', '300', 'g'), ('C', '400', 'h'); Select * from Tablename; SELECT DENSE_RANK() OVER ( ORDER BY ColA ) id, ColA as Folder, null as Parent from Tablename group by Folder; SELECT DENSE_RANK() OVER ( ORDER BY ColA,ColB ) id, ColB as Folder, DENSE_RANK() OVER ( ORDER BY ColA ) Parent From Tablename group by Folder order by id;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear