How check the existence of invoice no in sql?

Question

Hi,

 

   I want to know how to check the existence of invoice no in sql and if duplicate invoice no 

show a confirm box whether to insert?

what code should be written in js?

what should be returned from sql to check whether invoice no exits or not?