Home>

There is a query in DB2:

%sql select CASE_NUMBER from CHICAGO_CRIME_DATA where PRIMARY_TYPE= 'OFFENSE INVOLVING CHILDREN';

In response, I should receive the case numbers of the crimes I request. But I only get the title:

I copied the name of the table, column and required data in the cell from the table itself.

Please help me figure it out!

This usually happens because I didn't find anything.

Алексей Белкин2022-01-14 09:18:59

Welcome! Modify the question by adding textual information with text. To do this, click Edit under the question itself.

Dmitry2022-01-14 09:19:07

it is worth specifying the structure and a small data sample

Aleksey Vaganov2022-01-14 10:51:46

If to remove from request WHERE -the data is returned?

Akina2022-01-14 11:07:16

@Mikhail Alekseevich Bullshit, the client will figure it out. The main thing is to catch the very fact of receiving records. And the number ... yes, how many of those cases can there be? Well, a million, hardly more.

Akina2022-01-14 11:25:22