SELECT tb.id FROM pessoa tb GROUP BY tb.nome;

SELECT tb.id FROM pessoa WHERE tb.id>2 GROUP BY tb.id;

SELECT tb.id,tb.nome FROM pessoa tb ORDER BY tb.nome,tb.id;

SELECT * FROM pessoa tb GROUP BY tb.nome ORDER BY tb.id;

SELECT * FROM pessoa tb WHERE tb.id= "1" ORDER BY tb.nome;