SQL : Search column value using IN clause

WHERE  p.Year = @year
        AND (
        /*Always look at this*/
        p.LastName LIKE @name + '%'
       /*Only need to take account of FirstName if len(@name) <> 1 */
       OR ( len(@name) <> 1 AND p.FirstName LIKE @name + '%' )         
        )

SELECT * 
FROM table1 
WHERE (name="name1" OR name="name2") 
AND anotherid=1

id   name    anotherid  
1    name1   1
2    name2   1

SELECT * FROM table1 
GROUP BY anotherid

ID  NAME    ANOTHERID
1   name1   1
2   name2   2

SELECT * FROM table1
GROUP BY name

ID  NAME    ANOTHERID
1   name1   1
2   name2   1

SELECT DATE_FORMAT(Checktime,'%H:%i:%s') as TIME from TABLE_NAME where UserId=1 and Checktype='I' and Checktime>='12/04/2015' and Checktime <'13/04/2015'

SELECT CONVERT(TIME,Checktime) AS TIME from TABLE_NAME where UserId=1 and Checktype='I' and Checktime>='12/04/2015' and Checktime <'13/04/2015'

WHERE (JobRole = 'Supervisor') -- is supervisor
OR (JobRole = 'Subordinate Type 1'  -- or is Subordinate Type 1 and...
    and Event not in (select distinct event -- not is event with superv.
                      from Table 
                      where JobRole = 'Supervisor') 
   )