Database

select studentname
from studentmaster
where not exists
(select top 1 *
from feesregister
where regisrationnumber = studentmaster.registrationnumber
and feesofmonth='march' 
and session='2007-2008' 
and class='3' 
and section='a')

s.sathyanarayanan wrote:

can any of you tell me how to retrieve the no of records fetched thru a
fulltext CONTAINS query??

s.sathyanarayanan wrote:

select * from tablename where CONTAINS(Username,'Keyword')

.CS wrote:

select *

John Mecas wrote:

select * statement should return only those columns which don`t contain a NULL value

<br />
select name,isnull(occupation,'yadayadayada'),age<br />
from persons<br />
where occupation <> 'yadayadayada'

<br />
select name,occupation,age<br />
from persons<br />
where occupation is not null

LyndonJohn wrote:

the user can search for the different products

select month(Post_Date) as Post_Month,
    year(Post_Date) as Post_Year,
    sum(case when Status = 'Active' then 1 else 0 end) as Active,
    sum(case when Status = 'Inactive' then 1 else 0 end) as Billed
from tbl_Post_Job
where Company_Id_Fk = 60
group by year(Post_Date), month(Post_Date)
order by year(Post_Date), month(Post_Date)