select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'ZH' order by rank asc limit 0,100 Surnames > Z > ZH > ZHA

Surnames > Z > ZH > ZHA

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
ZA ZB ZD ZE ZG ZH ZI ZL ZM ZN ZO ZR ZS ZU ZV ZW ZY
ZHA ZHE ZHI ZHO ZHU

Full Surname List Starting with ZHA(Alphabetical)

ZHA
ZHAGNAY
ZHAGUI
ZHAI
ZHAMKOCHYAN
ZHAN
ZHANAY
ZHANG
ZHAO

Top 100 Surnames in the 2010 US Census starting with ZHA

SurnameCountRankWiki?
ZHANG 70125 472 no
ZHAO 22301 1613 no
ZHAN 1104 23120 no
ZHAI 806 29334 no
ZHAGUI 394 52619 no
ZHA 211 88020 no
ZHAGNAY 134 127494 no
ZHAMKOCHYAN 119 140157 no
ZHANAY 106 153769 no