db_venik |
|
View: stock02
db_venik |
|
View: stock02
Schema
Owner
albenard
Descriptions
There is no description for view stock02
Columns
Name | Data type | Description |
|---|---|---|
idlot_gr |
integer |
|
max |
integer |
|
min |
numeric |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table stock02
Definition
idlot_gr,
max,
min)
AS
SELECT sortie_graine.idlot_gr,
max(sortie_graine.idsortie_gr) AS max,
min(sortie_graine.qte_restante) AS min
FROM sortie_graine
GROUP BY sortie_graine.idlot_gr
HAVING min(sortie_graine.qte_restante) = 0::numeric;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) |
|