Article View: pl.comp.bazy-danych
Article #195294CASE .. WHEN .. THEN
From: piotr.pawel.olczyk
Date: Tue, 28 Mar 2017 15:04
Date: Tue, 28 Mar 2017 15:04
14 lines
1408 bytes
1408 bytes
Witam, Mam pytanie czy w CASE .. WHEN .. THEN po THEN może być blok instrukcji? np. ..... select wartosc, case when wartosc >= 10 then -> tu blok instrukcji przypisujących wartości w różnych kolumnach end, ..... from tabela Z góry dziękuje za odpowiedź
Technical Details
Message-ID:
<1305c9a3-bc01-46bc-b059-8c77e7bbb5cc@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!y18no1176507itc.0!news-out.google.com!i72ni393itb.0!nntp.google.com!y18no1171307itc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailShow Full Headers
Complete Article Headers
X-Received: by 10.99.1.138 with SMTP id 132mr5761477pgb.162.1490713444512; Tue, 28 Mar 2017 08:04:04 -0700 (PDT) X-Received: by 10.157.46.203 with SMTP id w69mr2125073ota.5.1490713444429; Tue, 28 Mar 2017 08:04:04 -0700 (PDT) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!y18no1176507itc.0!news-out.google.com!i72ni393itb.0!nntp.google.com!y18no1171307itc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych Date: Tue, 28 Mar 2017 08:04:04 -0700 (PDT) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=217.96.242.194; posting-account=CYbkygoAAADUpujeNdCrDeXfOltCVJNe NNTP-Posting-Host: 217.96.242.194 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <1305c9a3-bc01-46bc-b059-8c77e7bbb5cc@googlegroups.com> Subject: CASE .. WHEN .. THEN From: piotr.pawel.olczyk@gmail.com Injection-Date: Tue, 28 Mar 2017 15:04:04 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit