效果圖如下
IF OBJECT_ID(N'TEMPDB.DBO.#T') IS NOT NULL
DROP TABLE #T
GO
CREATE TABLE #T
(ID VARCHAR(10),
Concrete VARCHAR(20),
Munber VARCHAR(20),
GCMC VARCHAR(20),
WZ VARCHAR(20),
FS VARCHAR(20),
sj datetime,
FL decimal(18,2),
SEQ VARCHAR(20)
)
INSERT INTO #T (ID,Concrete,Munber,GCMC,WZ,FS,sj,FL,SEQ)
SELECT '1-1','00600','連州市旅游','橋柱','C10','泵','2019-10-02 15:55:05','90','' UNION ALL
SELECT '1-1','00601','連州市廠房','拉鋸設備底座','C30','天泵','2019-10-02 16:05:05','10','' UNION ALL
SELECT '1-1','00602','連州市廠房','拉鋸設備底座','C30','天泵','2019-10-02 17:00:48','90','' UNION ALL
SELECT '1-1','00603','連州市廠房','拉鋸設備底板','C30','天泵','2019-10-02 19:33:45','100','' UNION ALL
SELECT '1-1','00604','連州市廠房','拉鋸設備底板','C30','天泵','2019-10-02 20:07:07','110','' UNION ALL
SELECT '1-1','00605','連州市廠房','拉鋸設備底座','C30','天泵','2019-10-02 20:22:20','190','' UNION ALL
SELECT '1-1','00606','玻璃橋','底座','C55','直卸','2019-10-02 21:00:00','201','' UNION ALL
SELECT '1-2','00111','玻璃橋','底座','C55','直卸','2019-10-02 22:00:00','120','' UNION ALL
SELECT '1-2','00112','玻璃橋','柱','C30','直卸','2019-10-02 22:30:00','30','' UNION ALL
SELECT '1-2','00113','玻璃橋','底座','C55','直卸','2019-10-02 23:30:00','150','' UNION ALL
SELECT '1-2','00115','天橋','底座','C35','直卸','2019-10-03 00:30:00','1',''
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/104683.html
標籤：疑難問題
下一篇：sql優化-mysql