SELECT TOP 5 * FROM(SELECT * FROM AA WHERE 1=1 and kind=0 AND type=1 OR type=0 and kind=0 UNION ALL SELECT * FROM AA WHERE 1=1 AND type=2 and kind=0) AS A ORDER BY NEWID()SELECT TOP 20 * FROM(SELECT * FROM AA WHERE 1=1 and kind=1 AND type=1 OR type=0 and kind=1 UNION ALL SELECT * FROM AA WHERE 1=1 AND type=2 and kind=1) AS A ORDER BY NEWID()SELECT TOP 5 * FROM(SELECT * FROM AA WHERE 1=1 and kind=2 AND type=1 OR type=0 and kind=2 UNION ALL SELECT * FROM AA WHERE 1=1 AND type=2 and kind=2) AS A ORDER BY NEWID()SELECT TOP 15 * FROM(SELECT * FROM AA WHERE 1=1 and kind=3 AND type=1 OR type=0 and kind=3 UNION ALL SELECT * FROM AA WHERE 1=1 AND type=2 and kind=3) AS A ORDER BY NEWID()SELECT TOP 5 * FROM(SELECT * FROM AA WHERE 1=1 and kind=4 AND type=1 OR type=0 and kind=4 UNION ALL SELECT * FROM AA WHERE 1=1 AND type=2 and kind=4) AS A ORDER BY NEWID()上面的sql语句是查询出来的多个表,要求,把它们合成一张大表,就是并起来,要怎么做呢?
谢谢
谢谢
解决方案 »
- VS 诡异问题
- asp.net sql 读写 text型数据
- 智能表单中利用反射动态添加控件页面刷新的若干问题
- Windows2003安装IIS后,ASPX无法运行。(急!)
- 急需,网页在线聊天
- 大家做网站前用dreamweaver 先画布局吗?
- 怎么样防止页面刷新???
- 正则表达式:怎么实现url http:// 后边跟的不是"search"
- 我想问一下,c#中是否有类似于像邮箱那样的……(在线等待)
- 访问关系数据库的多种好方法!欢迎各位数据库应用的朋友们来作客!
- 在asp.net应用程序中怎样用水晶报表?
- ASP.net 如何实现把指定网页保存到指定文件夹中?保存的结果要和执行IE的“另存为”命令一样,但不是javascript实现的
合并多次查询的结果