B*g
2 楼
So here you suppose when you run
"SELECT A FROM table"
the return will be
1
2
3
...
???
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT NVL ((SELECT A
FROM table
WHERE ((B != 0) OR (B IS NULL))
AND ROWNUM = 1), (SELECT A
FROM (SELECT ROWNUM seqno,
A
FROM table)
WHERE seqno = (SELECT
【在 cd 的大作中提到】
: 有一个table，有两列，具体数据大致是这样的
: A B
"SELECT A FROM table"
the return will be
1
2
3
...
???
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT NVL ((SELECT A
FROM table
WHERE ((B != 0) OR (B IS NULL))
AND ROWNUM = 1), (SELECT A
FROM (SELECT ROWNUM seqno,
A
FROM table)
WHERE seqno = (SELECT
【在 cd 的大作中提到】
: 有一个table，有两列，具体数据大致是这样的
: A B
cd
3 楼
Thanks a lot!
B*g
4 楼
你这个应该有个order by吧，要不oracle可不一定按顺序。
【在 cd 的大作中提到】
: Thanks a lot!
【在 cd 的大作中提到】
: Thanks a lot!
相关阅读
Re: How to answer these questions? ThanksDoes anybody have a certificate of MSDBA?C-Bioinformatics, a new yahoo mailing list请教一个数据库设计的问题谁知道哪有Data Mining: Concepts and Techniques的电子英文版？pb8怎么连接oracle8.1.7?Re:(解决了) 大俠 问个关于asp连SQL server的问题How to load data into Mysql from txt file?Looking for DB SW急!请教 multidimensional data 的作图问题One Difficult Relational Algebra Question数据库方向的UNIV。？我的EA Server怎么回事?Re: How to connect to Access 2000 database with database password in ODBCoracle nologging mode --- Help, please那里有比较完整的IP地址来源数据库?Re: 谁知道哪有Data Mining: Concepts and Techniques的电子英文版？安装mysql遇见的问题。[转载] Re: 还有人用Windows 3.1吗？急急急！谁知道SAS软件是哪一年出来的。