[NULL 인 행을 출력하는 연산자]
mysql> SELECT last_name, manager_id
-> FROM employees
-> WHERE manager_id = NULL;
!! null 값에는 = 을 못씀
mysql> SELECT last_name, manager_id
-> FROM employees
-> WHERE manager_id IS NULL;
[AND 연산자]
mysql> SELECT employee_id, last_name, job_id, salary
-> FROM employees
-> WHERE salary >= 10000
-> AND job_id LIKE '%MAN%';
mysql> SELECT employee_id, last_name, job_id, salary
-> FROM employees
-> WHERE salary >= 10000 AND job_id LIKE '%MAN%';
+-------------+-----------+--------+----------+
| employee_id | last_name | job_id | salary |
+-------------+-----------+--------+----------+
| 114 | Raphaely | PU_MAN | 11000.00 |
| 145 | Russell | SA_MAN | 14000.00 |
| 146 | Partners | SA_MAN | 13500.00 |
| 147 | Errazuriz | SA_MAN | 12000.00 |
| 148 | Cambrault | SA_MAN | 11000.00 |
| 149 | Zlotkey | SA_MAN | 10500.00 |
| 201 | Hartstein | MK_MAN | 13000.00 |
+-------------+-----------+--------+----------+
[OR 연산자]
mysql> SELECT employee_id, last_name, job_id, salary
-> FROM employees
-> WHERE salary >= 10000 OR job_id LIKE '%MAN%';
mysql> SELECT employee_id, last_name, job_id, salary
-> FROM employees
-> WHERE salary >= 10000
-> OR job_id LIKE '%MAN%';
+-------------+-----------+---------+----------+
| employee_id | last_name | job_id | salary |
+-------------+-----------+---------+----------+
| 100 | King | AD_PRES | 24000.00 |
| 101 | Kochhar | AD_VP | 17000.00 |
| 102 | De Haan | AD_VP | 17000.00 |
| 108 | Greenberg | FI_MGR | 12000.00 |
| 114 | Raphaely | PU_MAN | 11000.00 |
| 120 | Weiss | ST_MAN | 8000.00 |
| 121 | Fripp | ST_MAN | 8200.00 |
| 122 | Kaufling | ST_MAN | 7900.00 |
| 123 | Vollman | ST_MAN | 6500.00 |
| 124 | Mourgos | ST_MAN | 5800.00 |
| 145 | Russell | SA_MAN | 14000.00 |
| 146 | Partners | SA_MAN | 13500.00 |
| 147 | Errazuriz | SA_MAN | 12000.00 |
| 148 | Cambrault | SA_MAN | 11000.00 |
l 149 | Zlotkey | SA_MAN | 10500.00 |
| 150 | Tucker | SA_REP | 10000.00 |
| 156 | King | SA_REP | 10000.00 |
| 162 | Vishney | SA_REP | 10500.00 |
| 168 | Ozer | SA_REP | 11500.00 |
| 169 | Bloom | SA_REP | 10000.00 |
| 174 | Abel | SA_REP | 11000.00 |
| 201 | Hartstein | MK_MAN | 13000.00 |
| 204 | Baer | PR_REP | 10000.00 |
| 205 | Higgins | AC_MGR | 12000.00 |
+-------------+-----------+---------+----------+
여러 개의 조건식들을 조합하여 사용할 수 있는 연산자
연산자의 우선순위에 의해서 AND가 OR보다 무조건 우선 연산이 이루어진다.
이 경우 OR이 더 먼저 연산되어야 하는경우 괄호()를 활용하여 연산 우선순위를 높여 줄 수 있다.
mysql> SELECT employee_id, last_name, job_id, salary
-> FROM employees
-> WHERE salary >= 10000 AND (job_id LIKE '%MAN%' OR job_id LIKE '%REP%');
[NOT 연산자]
between A and B 으로 가정한다면, A ~ B 를 제외한 모든 구간을 지칭함.
null 값이 아닌 것들로 출력
[NOT의 위치에 따라 값을 출력하는 2가지 방법]
1)
mysql> SELECT job_id, salary, last_name, commission_pct
-> FROM employees
-> WHERE commission_pct IS NOT NULL;
+--------+----------+------------+----------------+
| job_id | salary | last_name | commission_pct |
+--------+----------+------------+----------------+
| SA_MAN | 14000.00 | Russell | 0.40 |
| SA_MAN | 13500.00 | Partners | 0.30 |
| SA_MAN | 12000.00 | Errazuriz | 0.30 |
| SA_MAN | 11000.00 | Cambrault | 0.30 |
| SA_MAN | 10500.00 | Zlotkey | 0.20 |
| SA_REP | 10000.00 | Tucker | 0.30 |
| SA_REP | 9500.00 | Bernstein | 0.25 |
| SA_REP | 9000.00 | Hall | 0.25 |
| SA_REP | 8000.00 | Olsen | 0.20 |
| SA_REP | 7500.00 | Cambrault | 0.20 |
| SA_REP | 7000.00 | Tuvault | 0.15 |
| SA_REP | 10000.00 | King | 0.35 |
| SA_REP | 9500.00 | Sully | 0.35 |
| SA_REP | 9000.00 | McEwen | 0.35 |
| SA_REP | 8000.00 | Smith | 0.30 |
| SA_REP | 7500.00 | Doran | 0.30 |
| SA_REP | 7000.00 | Sewall | 0.25 |
| SA_REP | 10500.00 | Vishney | 0.25 |
| SA_REP | 9500.00 | Greene | 0.15 |
| SA_REP | 7200.00 | Marvins | 0.10 |
| SA_REP | 6800.00 | Lee | 0.10 |
| SA_REP | 6400.00 | Ande | 0.10 |
| SA_REP | 6200.00 | Banda | 0.10 |
| SA_REP | 11500.00 | Ozer | 0.25 |
| SA_REP | 10000.00 | Bloom | 0.20 |
| SA_REP | 9600.00 | Fox | 0.20 |
| SA_REP | 7400.00 | Smith | 0.15 |
| SA_REP | 7300.00 | Bates | 0.15 |
| SA_REP | 6100.00 | Kumar | 0.10 |
| SA_REP | 11000.00 | Abel | 0.30 |
| SA_REP | 8800.00 | Hutton | 0.25 |
| SA_REP | 8600.00 | Taylor | 0.20 |
| SA_REP | 8400.00 | Livingston | 0.20 |
| SA_REP | 7000.00 | Grant | 0.15 |
| SA_REP | 6200.00 | Johnson | 0.10 |
+--------+----------+------------+----------------+
2) NOT의 위치는 아래와 같이 조건식의 바깥에 작성하는 것도 가능하다.
mysql> SELECT job_id, salary, last_name, commission_pct
-> FROM employees
-> WHERE NOT (commission_pct IS NULL);
+--------+----------+------------+----------------+
| job_id | salary | last_name | commission_pct |
+--------+----------+------------+----------------+
| SA_MAN | 14000.00 | Russell | 0.40 |
| SA_MAN | 13500.00 | Partners | 0.30 |
| SA_MAN | 12000.00 | Errazuriz | 0.30 |
| SA_MAN | 11000.00 | Cambrault | 0.30 |
| SA_MAN | 10500.00 | Zlotkey | 0.20 |
| SA_REP | 10000.00 | Tucker | 0.30 |
| SA_REP | 9500.00 | Bernstein | 0.25 |
| SA_REP | 9000.00 | Hall | 0.25 |
| SA_REP | 8000.00 | Olsen | 0.20 |
| SA_REP | 7500.00 | Cambrault | 0.20 |
| SA_REP | 7000.00 | Tuvault | 0.15 |
| SA_REP | 10000.00 | King | 0.35 |
| SA_REP | 9500.00 | Sully | 0.35 |
| SA_REP | 9000.00 | McEwen | 0.35 |
| SA_REP | 8000.00 | Smith | 0.30 |
| SA_REP | 7500.00 | Doran | 0.30 |
| SA_REP | 7000.00 | Sewall | 0.25 |
| SA_REP | 10500.00 | Vishney | 0.25 |
| SA_REP | 9500.00 | Greene | 0.15 |
| SA_REP | 7200.00 | Marvins | 0.10 |
| SA_REP | 6800.00 | Lee | 0.10 |
| SA_REP | 6400.00 | Ande | 0.10 |
| SA_REP | 6200.00 | Banda | 0.10 |
| SA_REP | 11500.00 | Ozer | 0.25 |
| SA_REP | 10000.00 | Bloom | 0.20 |
| SA_REP | 9600.00 | Fox | 0.20 |
| SA_REP | 7400.00 | Smith | 0.15 |
| SA_REP | 7300.00 | Bates | 0.15 |
| SA_REP | 6100.00 | Kumar | 0.10 |
| SA_REP | 11000.00 | Abel | 0.30 |
| SA_REP | 8800.00 | Hutton | 0.25 |
| SA_REP | 8600.00 | Taylor | 0.20 |
| SA_REP | 8400.00 | Livingston | 0.20 |
| SA_REP | 7000.00 | Grant | 0.15 |
| SA_REP | 6200.00 | Johnson | 0.10 |
+--------+----------+------------+----------------+
[ORDER BY 절]
내가 입력한 순서대로 값을 저장해서 정렬이 된 값을 보고싶을 때 씀.출력 결과를 사용자 원하는 기준으로 정렬하여 출력하는 옵션 절.
ORDER BY절의 정렬기준은 SELECT절에 사용하지 않은 컬럼이나 표현식들도 사용가능하다.
ASC : Ascending order, default (오름차순)
DESC : Descending order (내림차순)
| 숫자 | 문자 | 날짜 | |
| 오름차순, 사전순 (작은 값 - > 큰 값) |
1 - > 9 | ' A ' - > ' Z ' | 이전 날짜 - > 이후 날짜 |
| 내림차순 | 9 - > 1 | ' Z ' - > ' A ' | 이후 날짜 - > 이전 날짜 |
> ORDER BY 절은 보통 구문 끝절에 위치함.
ORDER BY + 기준 + 정렬 방식
mysql> SELECT last_name, job_id, department_id, hire_date
-> FROM employees
-> ORDER BY hire_date DESC;
> 정렬 방식을 생략하면 기본으로 ASC 가 적용됨?! 내림차순은 적용 안됨.
mysql> SELECT employee_id, last_name, salary*12 annsal
-> FROM employees
-> ORDER BY annsal ;
+-------------+-------------+-----------+
| employee_id | last_name | annsal |
+-------------+-------------+-----------+
| 132 | Olson | 25200.00 |
| 128 | Markle | 26400.00 |
| 136 | Philtanker | 26400.00 |
| 127 | Landry | 28800.00 |
| 135 | Gee | 28800.00 |
| 119 | Colmenares | 30000.00 |
| 131 | Marlow | 30000.00 |
| 140 | Patel | 30000.00 |
| 144 | Vargas | 30000.00 |
| 182 | Sullivan | 30000.00 |
| 191 | Perkins | 30000.00 |
| 118 | Himuro | 31200.00 |
| 143 | Matos | 31200.00 |
| 198 | OConnell | 31200.00 |
| 199 | Grant | 31200.00 |
| 126 | Mikkilineni | 32400.00 |
| 139 | Seo | 32400.00 |
| 117 | Tobias | 33600.00 |
| 130 | Atkinson | 33600.00 |
| 183 | Geoni | 33600.00 |
| 195 | Jones | 33600.00 |
| 116 | Baida | 34800.00 |
| 134 | Rogers | 34800.00 |
| 190 | Gates | 34800.00 |
| 187 | Cabrio | 36000.00 |
| 197 | Feeney | 36000.00 |
| 115 | Khoo | 37200.00 |
| 142 | Davies | 37200.00 |
| 181 | Fleaur | 37200.00 |
| 196 | Walsh | 37200.00 |
| 125 | Nayer | 38400.00 |
| 138 | Stiles | 38400.00 |
| 180 | Taylor | 38400.00 |
| 194 | McCain | 38400.00 |
| 129 | Bissot | 39600.00 |
| 133 | Mallin | 39600.00 |
| 186 | Dellinger | 40800.00 |
| 141 | Rajs | 42000.00 |
| 137 | Ladwig | 43200.00 |
| 189 | Dilly | 43200.00 |
| 188 | Chung | 45600.00 |
| 193 | Everett | 46800.00 |
| 192 | Bell | 48000.00 |
| 185 | Bull | 49200.00 |
| 107 | Lorentz | 50400.00 |
| 184 | Sarchand | 50400.00 |
| 200 | Whalen | 52800.00 |
| 105 | Austin | 57600.00 |
| 106 | Pataballa | 57600.00 |
| 124 | Mourgos | 69600.00 |
| 104 | Ernst | 72000.00 |
| 202 | Fay | 72000.00 |
| 173 | Kumar | 73200.00 |
| 167 | Banda | 74400.00 |
| 179 | Johnson | 74400.00 |
| 166 | Ande | 76800.00 |
| 123 | Vollman | 78000.00 |
| 203 | Mavris | 78000.00 |
| 165 | Lee | 81600.00 |
| 113 | Popp | 82800.00 |
| 155 | Tuvault | 84000.00 |
| 161 | Sewall | 84000.00 |
| 178 | Grant | 84000.00 |
| 164 | Marvins | 86400.00 |
| 172 | Bates | 87600.00 |
| 171 | Smith | 88800.00 |
| 154 | Cambrault | 90000.00 |
| 160 | Doran | 90000.00 |
| 111 | Sciarra | 92400.00 |
| 112 | Urman | 93600.00 |
| 122 | Kaufling | 94800.00 |
| 120 | Weiss | 96000.00 |
| 153 | Olsen | 96000.00 |
| 159 | Smith | 96000.00 |
| 110 | Chen | 98400.00 |
| 121 | Fripp | 98400.00 |
| 206 | Gietz | 99600.00 |
| 177 | Livingston | 100800.00 |
| 176 | Taylor | 103200.00 |
| 175 | Hutton | 105600.00 |
| 103 | Hunold | 108000.00 |
| 109 | Faviet | 108000.00 |
| 152 | Hall | 108000.00 |
| 158 | McEwen | 108000.00 |
| 151 | Bernstein | 114000.00 |
| 157 | Sully | 114000.00 |
| 163 | Greene | 114000.00 |
| 170 | Fox | 115200.00 |
| 150 | Tucker | 120000.00 |
| 156 | King | 120000.00 |
| 169 | Bloom | 120000.00 |
| 204 | Baer | 120000.00 |
| 149 | Zlotkey | 126000.00 |
| 162 | Vishney | 126000.00 |
| 114 | Raphaely | 132000.00 |
| 148 | Cambrault | 132000.00 |
| 174 | Abel | 132000.00 |
| 168 | Ozer | 138000.00 |
| 108 | Greenberg | 144000.00 |
| 147 | Errazuriz | 144000.00 |
| 205 | Higgins | 144000.00 |
| 201 | Hartstein | 156000.00 |
| 146 | Partners | 162000.00 |
| 145 | Russell | 168000.00 |
| 101 | Kochhar | 204000.00 |
| 102 | De Haan | 204000.00 |
| 100 | King | 288000.00 |
+-------------+-------------+-----------+
> 3번째 컬럼인 department_id 를 정렬해라 (정렬 방식을 명시 안함.=> 오름차순)
mysql> SELECT last_name, job_id, department_id, hire_date
-> FROM employees
-> ORDER BY 3;
+-------------+------------+---------------+------------+
| last_name | job_id | department_id | hire_date |
+-------------+------------+---------------+------------+
| Grant | SA_REP | NULL | 1999-05-24 |
| Whalen | AD_ASST | 10 | 1987-09-17 |
| Hartstein | MK_MAN | 20 | 1996-02-17 |
| Fay | MK_REP | 20 | 1997-08-17 |
| Raphaely | PU_MAN | 30 | 1994-12-07 |
| Khoo | PU_CLERK | 30 | 1995-05-18 |
| Baida | PU_CLERK | 30 | 1997-12-24 |
| Tobias | PU_CLERK | 30 | 1997-07-24 |
| Himuro | PU_CLERK | 30 | 1998-11-15 |
| Colmenares | PU_CLERK | 30 | 1999-08-10 |
| Mavris | HR_REP | 40 | 1994-06-07 |
| Weiss | ST_MAN | 50 | 1996-07-18 |
| Fripp | ST_MAN | 50 | 1997-04-10 |
| Kaufling | ST_MAN | 50 | 1995-05-01 |
| Vollman | ST_MAN | 50 | 1997-10-10 |
| Mourgos | ST_MAN | 50 | 1999-11-16 |
| Nayer | ST_CLERK | 50 | 1997-07-16 |
| Mikkilineni | ST_CLERK | 50 | 1998-09-28 |
| Landry | ST_CLERK | 50 | 1999-01-14 |
| Markle | ST_CLERK | 50 | 2000-03-08 |
| Bissot | ST_CLERK | 50 | 1997-08-20 |
| Atkinson | ST_CLERK | 50 | 1997-10-30 |
| Marlow | ST_CLERK | 50 | 1997-02-16 |
| Olson | ST_CLERK | 50 | 1999-04-10 |
| Mallin | ST_CLERK | 50 | 1996-06-14 |
| Rogers | ST_CLERK | 50 | 1998-08-26 |
| Gee | ST_CLERK | 50 | 1999-12-12 |
| Philtanker | ST_CLERK | 50 | 2000-02-06 |
| Ladwig | ST_CLERK | 50 | 1995-07-14 |
| Stiles | ST_CLERK | 50 | 1997-10-26 |
| Seo | ST_CLERK | 50 | 1998-02-12 |
| Patel | ST_CLERK | 50 | 1998-04-06 |
| Rajs | ST_CLERK | 50 | 1995-10-17 |
| Davies | ST_CLERK | 50 | 1997-01-29 |
| Matos | ST_CLERK | 50 | 1998-03-15 |
| Vargas | ST_CLERK | 50 | 1998-07-09 |
| Taylor | SH_CLERK | 50 | 1998-01-24 |
| Fleaur | SH_CLERK | 50 | 1998-02-23 |
| Sullivan | SH_CLERK | 50 | 1999-06-21 |
| Geoni | SH_CLERK | 50 | 2000-02-03 |
| Sarchand | SH_CLERK | 50 | 1996-01-27 |
| Bull | SH_CLERK | 50 | 1997-02-20 |
| Dellinger | SH_CLERK | 50 | 1998-06-24 |
| Cabrio | SH_CLERK | 50 | 1999-02-07 |
| Chung | SH_CLERK | 50 | 1997-06-14 |
| Dilly | SH_CLERK | 50 | 1997-08-13 |
| Gates | SH_CLERK | 50 | 1998-07-11 |
| Perkins | SH_CLERK | 50 | 1999-12-19 |
| Bell | SH_CLERK | 50 | 1996-02-04 |
| Everett | SH_CLERK | 50 | 1997-03-03 |
| McCain | SH_CLERK | 50 | 1998-07-01 |
| Jones | SH_CLERK | 50 | 1999-03-17 |
| Walsh | SH_CLERK | 50 | 1998-04-24 |
| Feeney | SH_CLERK | 50 | 1998-05-23 |
| OConnell | SH_CLERK | 50 | 1999-06-21 |
| Grant | SH_CLERK | 50 | 2000-01-13 |
| Hunold | IT_PROG | 60 | 1990-01-03 |
| Ernst | IT_PROG | 60 | 1991-05-21 |
| Austin | IT_PROG | 60 | 1997-06-25 |
| Pataballa | IT_PROG | 60 | 1998-02-05 |
| Lorentz | IT_PROG | 60 | 1999-02-07 |
| Baer | PR_REP | 70 | 1994-06-07 |
| Russell | SA_MAN | 80 | 1996-10-01 |
| Partners | SA_MAN | 80 | 1997-01-05 |
| Errazuriz | SA_MAN | 80 | 1997-03-10 |
| Cambrault | SA_MAN | 80 | 1999-10-15 |
| Zlotkey | SA_MAN | 80 | 2000-01-29 |
| Tucker | SA_REP | 80 | 1997-01-30 |
| Bernstein | SA_REP | 80 | 1997-03-24 |
| Hall | SA_REP | 80 | 1997-08-20 |
| Olsen | SA_REP | 80 | 1998-03-30 |
| Cambrault | SA_REP | 80 | 1998-12-09 |
| Tuvault | SA_REP | 80 | 1999-11-23 |
| King | SA_REP | 80 | 1996-01-30 |
| Sully | SA_REP | 80 | 1996-03-04 |
| McEwen | SA_REP | 80 | 1996-08-01 |
| Smith | SA_REP | 80 | 1997-03-10 |
| Doran | SA_REP | 80 | 1997-12-15 |
| Sewall | SA_REP | 80 | 1998-11-03 |
| Vishney | SA_REP | 80 | 1997-11-11 |
| Greene | SA_REP | 80 | 1999-03-19 |
| Marvins | SA_REP | 80 | 2000-01-24 |
| Lee | SA_REP | 80 | 2000-02-23 |
| Ande | SA_REP | 80 | 2000-03-24 |
| Banda | SA_REP | 80 | 2000-04-21 |
| Ozer | SA_REP | 80 | 1997-03-11 |
| Bloom | SA_REP | 80 | 1998-03-23 |
| Fox | SA_REP | 80 | 1998-01-24 |
| Smith | SA_REP | 80 | 1999-02-23 |
| Bates | SA_REP | 80 | 1999-03-24 |
| Kumar | SA_REP | 80 | 2000-04-21 |
| Abel | SA_REP | 80 | 1996-05-11 |
| Hutton | SA_REP | 80 | 1997-03-19 |
| Taylor | SA_REP | 80 | 1998-03-24 |
| Livingston | SA_REP | 80 | 1998-04-23 |
| Johnson | SA_REP | 80 | 2000-01-04 |
| King | AD_PRES | 90 | 1987-06-17 |
| Kochhar | AD_VP | 90 | 1989-09-21 |
| De Haan | AD_VP | 90 | 1993-01-13 |
| Greenberg | FI_MGR | 100 | 1994-08-17 |
| Faviet | FI_ACCOUNT | 100 | 1994-08-16 |
| Chen | FI_ACCOUNT | 100 | 1997-09-28 |
| Sciarra | FI_ACCOUNT | 100 | 1997-09-30 |
| Urman | FI_ACCOUNT | 100 | 1998-03-07 |
| Popp | FI_ACCOUNT | 100 | 1999-12-07 |
| Higgins | AC_MGR | 110 | 1994-06-07 |
| Gietz | AC_ACCOUNT | 110 | 1994-06-07 |
+-------------+------------+---------------+------------+
[다중컬럼]
-department_id 는 오름차순, 그 같은 값 내에서 salary가 내림차순으로 정렬이 됨. (개별적인 정렬)
-왼쪽부터 적용됨
-갯수 제한 없음
mysql> SELECT last_name, department_id, salary
-> FROM employees
-> ORDER BY department_id, salary DESC;
+-------------+---------------+----------+
| last_name | department_id | salary |
+-------------+---------------+----------+
| Grant | NULL | 7000.00 |
| Whalen | 10 | 4400.00 |
| Hartstein | 20 | 13000.00 |
| Fay | 20 | 6000.00 |
| Raphaely | 30 | 11000.00 |
| Khoo | 30 | 3100.00 |
| Baida | 30 | 2900.00 |
| Tobias | 30 | 2800.00 |
| Himuro | 30 | 2600.00 |
| Colmenares | 30 | 2500.00 |
| Mavris | 40 | 6500.00 |
| Fripp | 50 | 8200.00 |
| Weiss | 50 | 8000.00 |
| Kaufling | 50 | 7900.00 |
| Vollman | 50 | 6500.00 |
| Mourgos | 50 | 5800.00 |
| Sarchand | 50 | 4200.00 |
| Bull | 50 | 4100.00 |
| Bell | 50 | 4000.00 |
| Everett | 50 | 3900.00 |
| Chung | 50 | 3800.00 |
| Ladwig | 50 | 3600.00 |
| Dilly | 50 | 3600.00 |
| Rajs | 50 | 3500.00 |
| Dellinger | 50 | 3400.00 |
| Bissot | 50 | 3300.00 |
| Mallin | 50 | 3300.00 |
| Nayer | 50 | 3200.00 |
| Stiles | 50 | 3200.00 |
| Taylor | 50 | 3200.00 |
| McCain | 50 | 3200.00 |
| Davies | 50 | 3100.00 |
| Fleaur | 50 | 3100.00 |
| Walsh | 50 | 3100.00 |
| Cabrio | 50 | 3000.00 |
| Feeney | 50 | 3000.00 |
| Rogers | 50 | 2900.00 |
| Gates | 50 | 2900.00 |
| Atkinson | 50 | 2800.00 |
| Geoni | 50 | 2800.00 |
| Jones | 50 | 2800.00 |
| Mikkilineni | 50 | 2700.00 |
| Seo | 50 | 2700.00 |
| Matos | 50 | 2600.00 |
| OConnell | 50 | 2600.00 |
| Grant | 50 | 2600.00 |
| Marlow | 50 | 2500.00 |
| Patel | 50 | 2500.00 |
| Vargas | 50 | 2500.00 |
| Sullivan | 50 | 2500.00 |
| Perkins | 50 | 2500.00 |
| Landry | 50 | 2400.00 |
| Gee | 50 | 2400.00 |
| Markle | 50 | 2200.00 |
| Philtanker | 50 | 2200.00 |
| Olson | 50 | 2100.00 |
| Hunold | 60 | 9000.00 |
| Ernst | 60 | 6000.00 |
| Austin | 60 | 4800.00 |
| Pataballa | 60 | 4800.00 |
| Lorentz | 60 | 4200.00 |
| Baer | 70 | 10000.00 |
| Russell | 80 | 14000.00 |
| Partners | 80 | 13500.00 |
| Errazuriz | 80 | 12000.00 |
| Ozer | 80 | 11500.00 |
| Cambrault | 80 | 11000.00 |
| Abel | 80 | 11000.00 |
| Zlotkey | 80 | 10500.00 |
| Vishney | 80 | 10500.00 |
| Tucker | 80 | 10000.00 |
| King | 80 | 10000.00 |
| Bloom | 80 | 10000.00 |
| Fox | 80 | 9600.00 |
| Bernstein | 80 | 9500.00 |
| Sully | 80 | 9500.00 |
| Greene | 80 | 9500.00 |
| Hall | 80 | 9000.00 |
| McEwen | 80 | 9000.00 |
| Hutton | 80 | 8800.00 |
| Taylor | 80 | 8600.00 |
| Livingston | 80 | 8400.00 |
| Olsen | 80 | 8000.00 |
| Smith | 80 | 8000.00 |
| Cambrault | 80 | 7500.00 |
| Doran | 80 | 7500.00 |
| Smith | 80 | 7400.00 |
| Bates | 80 | 7300.00 |
| Marvins | 80 | 7200.00 |
| Tuvault | 80 | 7000.00 |
| Sewall | 80 | 7000.00 |
| Lee | 80 | 6800.00 |
| Ande | 80 | 6400.00 |
| Banda | 80 | 6200.00 |
| Johnson | 80 | 6200.00 |
| Kumar | 80 | 6100.00 |
| King | 90 | 24000.00 |
| Kochhar | 90 | 17000.00 |
| De Haan | 90 | 17000.00 |
| Greenberg | 100 | 12000.00 |
| Faviet | 100 | 9000.00 |
| Chen | 100 | 8200.00 |
| Urman | 100 | 7800.00 |
| Sciarra | 100 | 7700.00 |
| Popp | 100 | 6900.00 |
| Higgins | 110 | 12000.00 |
| Gietz | 110 | 8300.00 |
+-------------+---------------+----------+
'DB' 카테고리의 다른 글
| 7월 DB Data retrieval, Select (0) | 2022.08.23 |
|---|---|
| 0823 JSP - ((SELECT))DB 정보 조회, 레코드셋, ~ ((UPDATE)) (0) | 2022.08.23 |
| 8/17 DB - Order by 절 ~ Oracle , MobaXterm (0) | 2022.08.17 |
| 8/9 DB - 연산자 (0) | 2022.08.09 |
| 7/28 DB - 네트워크 기초 (0) | 2022.07.28 |
