读书人

大神帮忙看一上这个查询语句要如何写

发布时间: 2012-09-04 14:19:30 作者: rapoo

大神帮忙看一下这个查询语句要怎么写
SELECT *
FROM REALBASE201207
WHERE (SID = 3) order by time
查询结果如下


SIDPIDvlauetime
3112012-07-22 12:55:00.310
3232012-07-22 12:55:00.310
3312012-07-22 12:55:00.310
3422012-07-22 12:55:00.310
3522012-07-22 12:55:00.310
3112012-07-22 13:15:00.343
3242012-07-22 13:15:00.343
3312012-07-22 13:15:00.343
34202012-07-22 13:15:00.343
3522012-07-22 13:15:00.343
31122012-07-22 13:25:00.373
32422012-07-22 13:25:00.373
33122012-07-22 13:25:00.373
34222012-07-22 13:25:00.373
35112012-07-22 13:25:00.373

现在我想要的表如下:
time12345
2012-07-22 12:55:00.31013122
2012-07-22 13:15:00.343141202
2012-07-22 13:25:00.3731242122211
想了好久没想出来,大神们帮我想想要怎么写


[解决办法]
参考:
http://blog.csdn.net/ajaxchen_615/article/details/3941856

动态,静态的都有...

读书人网 >SQL Server

热点推荐