Click here to Skip to main content
15,508,758 members

Comments by virel rakholiya (Top 3 by date)

virel rakholiya 5-Apr-16 4:51am View    
Use Below Statement...

SELECT * FROM data
WHERE temp_hi = (SELECT MAX(temp_hi) FROM data)
virel rakholiya 13-Nov-14 2:28am View    
thanks
virel rakholiya 13-Nov-14 1:51am View    
select F.IsNFO,*
from FAInvStatic f
inner join SCHEME_DETAILS sd on f.SchCode = sd.SCHEMECODE
--and case when fis.IsNFO =1 then DATEADD(DD,5,SD.NFO_CLOSE) >= GETDATE() end

if F.isnfo=1 then only condition check else no condition check