Select Command

1. select * from inventry
2. select iid,qty from inventry
3. select distinct supid,qty from inventry

Select using 'like'

1.select * from tblemp
where eadd like 'd_'

2.select * from tblemp
where eadd like '%d'

3.select * from tblemp
where eadd  like '%d%' and ename like 'u%'