Intrinsic Second-Order Anomalous Hall Effect and Its Application in Compensated Antiferromagnets