http://blog.naver.com/gladiator67/137516355
ODBC를 이용한 C++ DB연동하기C언어 오라클연동 2011/04/20 18:32 http://blog.naver.com/poiq1/80128626381 OBDC를 이용한 C++ DB연동하기 해당 DB에 연동 후 select로 테이블 조회값 불러오기 #include #include #include CWinApp theApp; using namespace std; int main() { CDatabase db; db.OpenEx(_T("DSN=ldh")); CRecordset rs(&db); rs.Open(CRecordset::dynaset,"SELECT * FROM school"); short colum = rs.GetODBCFieldCount(); char *data = NULL; if(colum>0..
1. 13시간 전 종목별 거래 SELECT B.* FROM StockPrice AS B, [SELECT MAX(IID) AS AB FROM (SELECT IID, Code FROM StockPrice WHERE DATEDIFF("h",DateTime,NOW())=13) GROUP BY Code ]. AS C WHERE B.IID = C.AB; 2. 종목별 최근(최종) 거래 SELECT SP.* FROM StockPrice AS SP, [SELECT MAX(IID) AS MAXIID FROM StockPrice GROUP BY Code; ] AS PT WHERE SP.IID=PT.MAXIID; 3. 특정시간 후 1% 이상 오른 종목 (1 + 2 = 3) SELECT X.*, Y.Diff AS ['13시간전..