sql 예시 1

상위 100개

select top(100) * from stock.dbo.Logday;

LogNo 기준으로 하위 100개

SELECT TOP (1000) * from stock.dbo.Log5Minute where stockcode='A000040' order by logno desc

삼성전자 일봉전체

select * from stock.dbo.logday where stockcode = 'A005930';

삼성전자 특정일봉

select * from stock.dbo.logday where stockcode='A005930' and logdate=20180903;

특정일 시총5천억 이상

select * from stock.dbo.logday where logdate=20180903 and marketCap>5000*10000*10000;

특정기간 시총5천억 이상

select * from stock.dbo.logday where 20180806<=logdate and logdate<=20180831 and marketCap>5000*10000*10000;

특정기간 시총5천억 이상 종목명,날짜,종가

select stockcode, logdate, priceClose, marketCap 

from stock.dbo.logday 

where 20180806<=logdate and logdate<=20180831 and marketCap>5000*10000*10000;