急救!!!求一sql语句

Question

select * from table where col1=col1;

Answer 1

select * from table where col1=col1

Answer 2

兩種方法：SQL> select * from bao_temp 
  2  where col1=col1
  3  /COL1             COL2        SEQ
---------- ---------- ----------
A                  31          2
A                  11          4
A                  21          3
B                  11          4
B                  21          3
B                  31          2
C                  31          2
C                  11          4
C                  21          3
B                  45          4
C                  56          1COL1             COL2        SEQ
---------- ---------- ----------
C                  78          5選取了 12 列目前歷時: 00:00:00.40
SQL> select * from bao_temp 
  2  where col1 like '%%'
  3  /COL1             COL2        SEQ
---------- ---------- ----------
A                  31          2
A                  11          4
A                  21          3
B                  11          4
B                  21          3
B                  31          2
C                  31          2
C                  11          4
C                  21          3
B                  45          4
C                  56          1COL1             COL2        SEQ
---------- ---------- ----------
C                  78          5選取了 12 列目前歷時: 00:00:00.40

Answer 3

赞同 ORARichard(没钱的日子......) 的意见，不过不知道搂主是个啥意思！

Answer 4

select * from table where col1=???　or 1=1如果你想要的没有，就出来全部

Answer 5

select * from table where 1=1
加个真条件就行了