Tweeted twitter.com/#!/StackDBAs/status/108065206797733889

occurred Aug 29, 2011 at 6:35

edited body

Source Link

edited Aug 25, 2011 at 20:33

I have the following query which works for me:

select count(*)
from (
   select UNIQUE col1, col2, col3
   from my_table
   where cond1 = 'A'
   and cond2 = 'B'
   and cond3 = 'C'
})

Is it possible to write this without the nested query?

I have the following query which works for me:

select count(*)
from (
   select UNIQUE col1, col2, col3
   from my_table
   where cond1 = 'A'
   and cond2 = 'B'
   and cond3 = 'C'
}

Is it possible to write this without the nested query?

I have the following query which works for me:

select count(*)
from (
   select UNIQUE col1, col2, col3
   from my_table
   where cond1 = 'A'
   and cond2 = 'B'
   and cond3 = 'C'
)

Is it possible to write this without the nested query?

Source Link

asked Aug 25, 2011 at 20:30

Shortest Query to Combine Count and Unique (Oracle)

I have the following query which works for me:

select count(*)
from (
   select UNIQUE col1, col2, col3
   from my_table
   where cond1 = 'A'
   and cond2 = 'B'
   and cond3 = 'C'
}

Is it possible to write this without the nested query?

Return to Question