All Questions
3 questions
0
votes
1
answer
50
views
WITH-clause not pre-calculated, lineal resource wasting, why?
I'm trying to save resources, and shorten code, but getting lineal resource wasting with "WITH-clause".
This is my base example:
#!/bin/bash
echo "CREATE TABLE 'clients_table' ( id ...
- 18
2
votes
1
answer
144
views
Select where next row's value is greater
I have a road_insp table.
create table road_insp
(
insp_id int,
road_id int,
insp_date date,
condition number(38,2)
) ;
insert into road_insp (insp_id, road_id, ...
- 1,497
1
vote
1
answer
2k
views
Select statement for selecting every week's log record
Here is a simplified version of the table in question:
+------------------------------------------------------+
| DatabaseName | LogRecordNumber | LogTimestamp |
+------------------------------...
- 135