Click here to Skip to main content
15,441,816 members

Comments by virel rakholiya (Top 3 by date)

virel rakholiya 5-Apr-16 4:51am View     CRLF
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     CRLF
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