SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table table_name ( a CHAR(255) ); INSERT INTO table_name (a) VALUES ('ttt'), ('www'), ('vvv'), ('zzz'), ('t'), ('a'), ('t'), ('z'), ('zz'), ('oo'), ('ttt'), ('www'), ('vvv'), ('zzz'), ('t'), ('t'), ('z'), ('zz'), ('oo'), ('uu'), ('uu'), ('uu'), ('oo'), ('j'); --select * from table_name -- 1.1 как вернуть только повторяющиеся значения select a from table_name as a cross join (select distinct a from table_name) as b -- 1.2. как вернуть только top-10 значений
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear