SQL -- Selecting Data

select *

                from empinfo

                where first = 'Eric'

The above examples SQL query selects all (*) columns from the empinfo table where the first name is Eric. See result of the query below.