topic Re: Where Clause problem in Application Development and Automation Discussions

Where Clause problem

Former Member — Fri, 08 Jul 2005 22:17:47 GMT

Hi Experts,

I have a requirement, where in i have to select all the columns from the table where the table names are like

/bic/a%00 etc and also the no.of rows must be greater than 100000.

So how do i write my open sql statement.

My query looks like this.

SELECT *

FROM DBSTATTORA

WHERE TNAME LIKE '/BIC/A%00'

OR TNAME LIKE '/BIC/A%40'

OR TNAME LIKE '/BI0/A%00'

OR TNAME LIKE '/BI0/A%40'

ORDER BY TNAME.

So in here i also want to include in the where clause that the NROWS > 100000.

But it doesn't allow me to do it.So how should i achieve this. This is really really important, So please any help on this will be great.

Thanks in advance,

Prabhu.

Re: Where Clause problem

ssimsekler — Fri, 08 Jul 2005 22:34:07 GMT

Hi Prabhu

SAP at upper level do not deal with the number of the row, so we can not use row number in WHERE clause.

Regards

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

Re: Where Clause problem

Former Member — Fri, 08 Jul 2005 22:49:55 GMT

I solved it, used brackets within the where clause and i get the accurate information for the no.of rows.

Thanks anyway.