국토교통부 실거래가 매매가격 통계조회(조건추가)

국토교통부 실거래가 매매가격 통계조회(조건추가)

조회조건)
1. 매매거래차이 DESC
2. 국토교통부 실거래가 매매가격 DESC
3. (최대매매-최소매매)/(최대매매)*100.0 - 같은아파트,같은평형 DESC
4. (최대매매-최소매매)/(최대매매)*100.0 - 같은아파트,같은평형 ASC

비고)화면이 늦게 나오므로, 인덱스생성

[2025-02-20 12:20:06]>SELECT CityCounty,LotNumber,TransactionAmount,Building,Buyer,Seller,ConstructionYear,RoadName,CancellationReasonDate,TransactionType,BrokerLocation,RegistrationDate FROM ANESTATEAPTALL WHERE MainNumber = '18' AND SubNumber = '10' AND ComplexName = '송도더샵하버뷰(D14)' AND AreaSquareMeters = '101.454' LIMIT 1 [2025-02-20 12:20:06]>SELECT DataClass,InfoMarketClass,TransactionTime,ComplexNo,CortarNo,RealEstateTypeCode,RealEstateTypeName,UseApproveYmd,CortarAddress,MinPriceByLetter,MaxPriceByLetter,MinLeasePriceByLetter,MaxLeasePriceByLetter,MinPrice,MaxPrice,MinLeasePrice,MaxLeasePrice FROM ESTATENAVERALLINFOATTACH WHERE CORTARADDRESS = '인천시 연수구 송도동' AND LNBRMNNM = '18' AND LNBRSLNO = '10' LIMIT 1; [2025-02-20 12:20:06]>SELECT CityCounty,LotNumber,TransactionAmount,Building,Buyer,Seller,ConstructionYear,RoadName,CancellationReasonDate,TransactionType,BrokerLocation,RegistrationDate FROM ANESTATEAPTALL WHERE MainNumber = '21' AND SubNumber = '59' AND ComplexName = '인천송도힐스테이트3단지' AND AreaSquareMeters = '142.359' LIMIT 1 [2025-02-20 12:20:06]>SELECT DataClass,InfoMarketClass,TransactionTime,ComplexNo,CortarNo,RealEstateTypeCode,RealEstateTypeName,UseApproveYmd,CortarAddress,MinPriceByLetter,MaxPriceByLetter,MinLeasePriceByLetter,MaxLeasePriceByLetter,MinPrice,MaxPrice,MinLeasePrice,MaxLeasePrice FROM ESTATENAVERALLINFOATTACH WHERE CORTARADDRESS = '인천시 연수구 송도동' AND LNBRMNNM = '21' AND LNBRSLNO = '59' LIMIT 1;

Microsoft Windows [Version 10.0.19045.2965] (c) Microsoft Corporation. All rights reserved. >sqlite3 "naver_attach_estate_info_file.db" SQLite version 3.48.0 2025-01-14 11:05:00 Enter ".help" for usage hints. sqlite> .tables ESTATENAVERALLINFOATTACH sqlite> PRAGMA index_list(ESTATENAVERALLINFOATTACH); sqlite> CREATE INDEX idx_cortar_lnbr ON ESTATENAVERALLINFOATTACH (CORTARADDRESS, LNBRMNNM, LNBRSLNO); sqlite> PRAGMA index_list(ESTATENAVERALLINFOATTACH); 0|idx_cortar_lnbr|0|c|0 sqlite> PRAGMA index_info(idx_cortar_lnbr); 0|9|CORTARADDRESS 1|18|LNBRMNNM 2|19|LNBRSLNO >sqlite3 "database_all_total.db" SQLite version 3.48.0 2025-01-14 11:05:00 Enter ".help" for usage hints. sqlite> PRAGMA index_list(ANESTATEAPTALL); sqlite> CREATE INDEX idx_apt_search ON ANESTATEAPTALL (MainNumber, SubNumber, ComplexName, AreaSquareMeters); sqlite> PRAGMA index_list(ANESTATEAPTALL); 0|idx_apt_search|0|c|0 sqlite> PRAGMA index_info(idx_apt_search); 0|4|MainNumber 1|5|SubNumber 2|6|ComplexName sqlite> .exit

index.html

0.02MB