dendenners
Programmer
Hi,
I want to get back the size of a resultset from an oracle select statement without actually bringing back the entire resultset (I'm just bringing back 20 or so rows). I could use an extra "SELECT COUNT(*)..." statement, but this seems to have problems when I use "SELECT DISTINCT....". Does anyone know the most efficient way possible of getting the size of a resultset along with a small selection of the resultset itself (using "WHERE ROWNUM BETWEEN..." to get back my actual selection)? Thanks
I want to get back the size of a resultset from an oracle select statement without actually bringing back the entire resultset (I'm just bringing back 20 or so rows). I could use an extra "SELECT COUNT(*)..." statement, but this seems to have problems when I use "SELECT DISTINCT....". Does anyone know the most efficient way possible of getting the size of a resultset along with a small selection of the resultset itself (using "WHERE ROWNUM BETWEEN..." to get back my actual selection)? Thanks