摘要:
1 select --* 2 request_session_id as spid, 3 resource_type as restype, 4 resource_database_id as dbid, 5 DB_NAME(resource_database_id) as dbname, 6 ... 阅读全文
posted @ 2015-06-30 17:38 happyst 阅读(158) 评论(0) 推荐(0)
|
摘要:
1 select --* 2 request_session_id as spid, 3 resource_type as restype, 4 resource_database_id as dbid, 5 DB_NAME(resource_database_id) as dbname, 6 ... 阅读全文
posted @ 2015-06-30 17:38 happyst 阅读(158) 评论(0) 推荐(0)
摘要:
http://www.cnblogs.com/huanghai223/archive/2010/10/26/1861961.html“从100万条记录中的得到成绩最高的记录”。看到这个题目,通常我们的做法是:select top 1 * from student order by score des... 阅读全文
posted @ 2015-06-30 15:17 happyst 阅读(138) 评论(0) 推荐(0) |
||