-
Birthdate Query
There is a table friends having following detailsName BirthdayJohn 28-jun-1985Peter 27-aug-1987Tom 13-aug-1986Nick 29-apr-1987Natalia 25-apr-1984Kate 28-jun-1984Wilson 11-nov-1987krish 31-jul-1987robert 25-apr-1984 SELECT names of the friends which come on the same day.. condition you don't know which birthday's repeat SELECT distinct...
-
How do I lock a column
How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted?