Pergunta de entrevista da empresa Salesforce: sql query to find count of students having same last name

Salesforce

sql query to find count of students having same last name

Sigiloso

21 de mar. de 2014

select count(LastName) from employees group by LastName having count(*)>1

Sigiloso

24 de set. de 2018

Select lastname, count(*) as lastnamecount from students group by lastname having count(*)>1

Sigiloso

6 de out. de 2013

select * from Students where lastName in (select s1.lastName from Students s1 group by s1.lastName having count(*)>1);