[Cb5.0] SELECT ~ FROM ~ WHERE 기본 구문

/*******************************************************************************************************************
-- Title : [Cb5.0] SELECT ~ FROM ~ WHERE 기본 구문
-- Reference : couchbase.com
-- Key word : select from where select raw select distinct raw use keys n1ql
*******************************************************************************************************************/

■ Scripts

-- SELECT vs. SELECT RAW
SELECT {"a":1, "b":2};
SELECT RAW {"a":1, "b":2};
 

-- SELECT RAW vs. SELECT DISTINCT RAW
SELECT city 
FROM `travel-sample` 
WHERE type="airport"
ORDER BY city LIMIT 5;
 
SELECT RAW city 
FROM `travel-sample`
WHERE type="airport"
ORDER BY city LIMIT 5;
 
SELECT DISTINCT RAW city 
FROM `travel-sample`
WHERE type="airport" 
ORDER BY city LIMIT 5;
 
SELECT DISTINCT city 
FROM `travel-sample` 
WHERE type="airport" 
ORDER BY city LIMIT 5;
 

-- LIMIT
SELECT * 
FROM `beer-sample` 
LIMIT 2;
 
SELECT city, code, geo, name 
FROM `beer-sample` 
LIMIT 5;
 

-- WHERE
SELECT * 
FROM `beer-sample` 
WHERE name = "21A IPA";
 

-- NULL
SELECT name, city, coucntry, geo 
FROM `beer-sample`
WHERE geo IS NOT NULL
LIMIT 100;
 

-- WHERE 계층 조건
SELECT * FROM `beer-sample`
WHERE geo.accuracy = "APPROXIMATE"
LIMIT 5;
 

-- SELECT 계층 조회
SELECT name, geo.accuracy, geo.lat 
FROM `beer-sample`
WHERE geo IS NOT NULL
LIMIT 100;
 
 
-- 리스트 조회
SELECT meta().id, email, city, phone, reviews[0].ratings 
FROM `travel-sample` 
WHERE type="hotel" 
LIMIT 5;
 
 
-- 메타 정보 출력
SELECT meta().*
FROM `beer-sample` 
LIMIT 5;
 
SELECT meta().id, meta().flags, meta().expiration, meta().cas
FROM `beer-sample` 
LIMIT 5;
 
 
-- USE KEYS
SELECT *
FROM `beer-sample`
WHERE meta().id = "21st_amendment_brewery_cafe";
 
SELECT *
FROM `beer-sample`
USE KEYS "21st_amendment_brewery_cafe";