| CARVIEW |
Select Language
HTTP/2 200
date: Sun, 12 Oct 2025 01:08:07 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=9d8544059116572ba1af3b564055e8f466c095afc8a076f1a75255d25659a571a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22k_MdlXnBfM1LFk133qD1BGB0jdVrGiBG%22%3B%7D; HttpOnly; Path=/
cf-ray: 98d2b44b8cdac1ba-BLR
Task 1 - SQL - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- a) без филтриране по INFO1
- SELECT
- AUFTRAGSNUMMER AS "Order number",
- DATUMAEXTERN AS "Order date created",
- KUNDENNR AS "BP number",
- NAME1 AS "Name of the client",
- MAINLAND AS "Country of the client",
- BSBELADESTART AS "Loading date start",
- BSBELADEEND AS "Loading date end",
- ESENTLADESTART AS "Unloading date start",
- ESENTLADEEND AS "Unloading date end",
- ABS_ORT1 AS "Loading City",
- EMP_ORT1 AS "Unloading City"
- FROM
- AKOPF
- LEFT JOIN
- SKUNDEN ON SKUNDEN.NR = AKOPF.FRACHTAGNR
- LEFT JOIN
- ASENDUNG ON AKOPF.NR = ASENDUNG.AKOPFNR;
- б) Полето INFO1 не е празно и не съдържа само space-ове
- SELECT
- AUFTRAGSNUMMER AS "Order number",
- DATUMAEXTERN AS "Order date created",
- KUNDENNR AS "BP number",
- NAME1 AS "Name of the client",
- MAINLAND AS "Country of the client",
- BSBELADESTART AS "Loading date start",
- BSBELADEEND AS "Loading date end",
- ESENTLADESTART AS "Unloading date start",
- ESENTLADEEND AS "Unloading date end",
- ABS_ORT1 AS "Loading City",
- EMP_ORT1 AS "Unloading City"
- FROM
- AKOPF
- LEFT JOIN
- SKUNDEN ON SKUNDEN.NR = AKOPF.FRACHTAGNR
- LEFT JOIN
- ASENDUNG ON AKOPF.NR = ASENDUNG.AKOPFNR
- WHERE
- TRIM(ASENDUNG.INFO1) <> ' ';
Advertisement
Add Comment
Please, Sign In to add comment
-
📌 Instant BTC Profit Method ✅ Working
JavaScript | 6 sec ago | 0.24 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ 3
JavaScript | 9 sec ago | 0.25 KB
-
📝 MAKE $2500 IN 15 MIN ✅ Working
JavaScript | 14 sec ago | 0.24 KB
-
⭐✅ Swapzone Glitch ✅ Working ⭐⭐ G
JavaScript | 19 sec ago | 0.25 KB
-
💵 Make 3000$ in 20 minutes 💵
JavaScript | 24 sec ago | 0.24 KB
-
✅ Make $2500 in 20 minutes⭐⭐⭐ U
JavaScript | 28 sec ago | 0.25 KB
-
📌 Swapzone +37% glitch
JavaScript | 33 sec ago | 0.24 KB
-
📌 Swapzone +37% glitch ⭐ W
JavaScript | 37 sec ago | 0.25 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
