大神帮忙看一下这个查询语句要怎么写
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
动态,静态的都有...