程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SqlServer數據庫 >> 關於SqlServer >> 如何刪除僅僅第一列相同的記錄?

如何刪除僅僅第一列相同的記錄?

編輯:關於SqlServer

問題描述:關系數據庫中手工輸入表InputData中有如下記錄,
TagNameTimeStampValue
MM00082007-08-12 0:00:001000
MM00082007-08-13 0:00:001001
MM00082007-08-14 0:00:001002
MM00082007-08-15 0:00:001003
MM00082007-08-16 0:00:001004
MM00082007-08-17 0:00:001005
MM00082007-09-07 9:50:224444
MM00082007-09-07 15:10:56100
MM00082007-09-07 15:11:56200
MM00082007-09-11 15:53:13500
MM00082007-09-11 15:54:51500
MM00082007-09-11 15:55:03123
MM00082007-09-11 15:58:08500
MM00082007-09-11 16:01:580
MM00092007-09-11 15:58:08501
MM00092007-09-11 16:01:580
MM00102007-09-11 15:58:08502
MM00102007-09-11 16:01:580
MM00112007-09-11 15:58:08503
MM00112007-09-11 16:01:580
MM00182007-09-11 15:58:08504
MM00182007-09-11 16:01:580
MM00192007-09-11 15:58:08505
MM00192007-09-11 16:01:580
MM00202007-09-11 15:58:08506
MM00202007-09-11 16:01:580
MM00212007-09-11 15:58:08507
MM00212007-09-11 16:01:580
MM00222007-09-11 15:58:08508
MM00222007-09-11 16:01:580
MM00232007-09-11 15:58:08509
MM00232007-09-11 16:01:580
MM00242007-09-11 15:58:08510
MM00242007-09-11 16:01:580
MM00252007-09-11 15:58:08511
MM00252007-09-11 16:01:580

  1. 上一頁:
  2. 下一頁: