1 2 3 4 5
--------------
a
b
c
d
c
5条记录
查询为
1 2 3 4 5
--------
a b c d e
sql怎么写
--------------
a
b
c
d
c
5条记录
查询为
1 2 3 4 5
--------
a b c d e
sql怎么写
解决方案 »
- 在线等,如何选出各科成绩的前10名的男同学有多少个
- 存储过程,解答哦
- 求一句统计语句
- 第 2 行: 'unsigned' 附近有语法错误。 帮忙解决!急,在线等
- sql server怎么在创建视图时加唯一标示?或者是否存在关键字?
- 有关存储过程的小问题?
- Conversion failed when converting the varchar value 'Bern' to data type int.
- 不通过试探连接数据库的方法如何判断本地计算机已经安装SQL Server?
- 存储过程中如何定义一个对应表名是变量的游标?
- 16位转换64位
- 求一SQL语句?
- 给我一个完整的事务处理的例子吧?!
(select col1 , px = (select count(1) from tb where col1 <> '' and col1 > t.col1) from tb t where col1 <> '') tb1,
(select col2 , px = (select count(1) from tb where col2 <> '' and col2 > t.col2) from tb t where col2 <> '') tb2,
(select col3 , px = (select count(1) from tb where col3 <> '' and col3 > t.col3) from tb t where col3 <> '') tb3,
(select col4 , px = (select count(1) from tb where col4 <> '' and col4 > t.col4) from tb t where col4 <> '') tb4,
(select col5 , px = (select count(1) from tb where col5 <> '' and col5 > t.col5) from tb t where col5 <> '') tb5
where tb1.px = tb2.px and tb1.px = tb3.px and tb1.px = tb4.px and tb1.px = tb5.px