what is the best way to do "nodupkey" ( SAS ) in mySQL ?

Question

Can any one please let me know what would be the most efficient way the create "nodupkey" like in mySQL thay would give the same result as SAS code here ?

  Proc sort data=T1 nodupkey out = T2; By ID; Run;

Thanks

Answer 1

seems like a simple distinct could be enough for your case, so your MySQL code should look like this:

create table T2 
 select distinct ID
 from T1

More information can be found here

Hope this help

EDIT:

As Mozan say this is supposed to work only if you have a single varible on your table, named ID