Comments by virel rakholiya

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

Comments by virel rakholiya (Top 3 by date)