Hugo
Hugo
Programming language:SQL
2021-03-21 22:13:32
0
Q:

how to find the top 2 unique records using mysql

Dan93
Dan93
Code: SQL
2021-08-10 02:21:49 
mysql> insert into DemoTable1383 values(200,78);
Query OK, 1 row affected (0.10 sec)
mysql> insert into DemoTable1383 values(200,89);
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable1383 values(200,89);
Query OK, 1 row affected (0.10 sec)
mysql> insert into DemoTable1383 values(200,87);
Query OK, 1 row affected (0.29 sec)
mysql> insert into DemoTable1383 values(203,97);
Query OK, 1 row affected (0.20 sec)
mysql> insert into DemoTable1383 values(200,57);
Query OK, 1 row affected (0.17 sec)
insert into DemoTable1383 values(240,20);
0
Sierra
Sierra
Code: SQL
2021-07-12 17:26:23 

 SELECT DISTINCT column1, column2, ...

 FROM table_name;
0

Tags

Related

New to Communities?

Join the community