Skip to Content
0
Former Member
Oct 26, 2010 at 01:32 PM

Select data from table where field is initial

20 Views

I have table that has 10 million records.

I want to select data from this table where certain date field is blank.

*SELECT * FROM table*

INTO TABLE internal table

WHERE PSTNG_DATE = BLANK.

Does anybody know how to select data from data base table when certain field is blank.

I cont select all data once and delete which i dont want, the table is big, it will blow up app server.

thanks in advance,

Sachin

-


Moderator: Pls do not lock the posting instead provide me the link, its disrespecting.