31.10.2010

use forumDB
go

select * from userTbl where soyadi like '%EK%'


select adi+' '+soyadi,email from userTbl

select adi+' '+soyadi as 'Ad Soyad',email as 'E Mail Adresi' from userTbl


select * from userTbl where age between 20 and 40 and adi like '%a%'

select * from userTbl order by id desc -- asc



___select SQL___