Óñëîâèå îòáîðà áåç çíà÷åíèÿ)
|
|
Ñóááîòà, 20 Ìàÿ 2017 ã. 19:35
+ â öèòàòíèê
Èìååòñÿ çàïðîñ íà âûáîðêó èç òàáëèöû.
 òàáëèöå îäíî, ÷èñëîâîå, ïîëå ÿâëÿåòñÿ óñëîâèåì îòáîðà äëÿ çàïðîñà.
 çàïðîñå îòáîð ïðîèçâîäèòñÿ ïîäñòàíîâêîé â ôóíêöèþ FUN_ZNACHENIE() - óñëîâèÿ îòáîðà.
SELECT Tabl.*
FROM Tabl
WHERE (Tabl.Vibor)=FUN_ZNACHENIE())
íàïðèìåð
FUN_ZNACHENIE - 1
çàïðîñ îòîáðàæàåò âñå çàïèñè, ãäå â äàííîì ïîëå ñòîèò 1
FUN_ZNACHENIE - 3
çàïðîñ îòîáðàæàåò âñå çàïèñè, ãäå â äàííîì ïîëå ñòîèò 3
=======================================
À êàêîå çàäàòü çíà÷åíèå äëÿ îòîáðàæåíèÿ âñåõ çàïèñåé?
------------------------------------------------------------------------
ÑÏÑ
http://www.sql.ru/forum/1260659/uslovie-otbora-bez-znacheniya
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-