索引
语言查询基础查询select 查询列表 from 表名;查询函数（调用函数，获取返回值）起别名+的作用distinct的使用（去重）查看表的结构 条件查询按关系表达式筛选按逻辑表达式筛选模糊查询likeinbetween andis null 排序查询按单个字段排序按表达式排序按别名排序按函数的结果排序按多个字段排序按列数排序mysql的sqlyog学习笔记（高级查询部分）（代码用命令行显示 ）
mysql的sqlyog学习（函数部分）（代码用命令行显示 ）
SQL学习（语法，基础，高级）（待续）
语言
DQL(data query language)（数据 查询 语言）
SQL(s=select)（选择 查询 语言）
DML(data manipulation language)(数据 操作 语言）
DDL(data define language)(数据定义语言)
TCL(transaction control language)(事务控制语言)
查询
基础查询
select 查询列表 from 表名;
特点：查询的结果集 是一个虚拟表（打印内容）
select后面跟的查询列表，可以有多个部分组成，中间用逗号隔开：select 字段1,字段2,表达式 from 表;
执行顺序
① from子句
② select子句
查询列表可以是：字段、表达式、常量、函数等
USE myemployees;
一、查询常量
SELECT 100 ;
二、查询表达式
SELECT 100%3;
三、查询单个字段
SELECTlast_nameFROMemployees;
四、查询多个字段
SELECTlast_name,email,employee_idFROM employees;
五、查询所有字段
SELECT * FROMemployees;
查询函数（调用函数，获取返回值）
SELECT DATABASE();
SELECT VERSION();
SELECT USER();
起别名
方式一：使用as关键字
SELECT USER() AS 用户名;
SELECT USER() AS “用户名”;
SELECT USER() AS ‘用户名’;
SELECT last_name AS “姓 名” FROM employees;
方式二：使用空格
SELECT USER() 用户名;
SELECT USER() “用户名”;
SELECT USER() ‘用户名’;
SELECT last_name “姓 名” FROM employees;
mysql> select last_name as 'xing ming' from employees;+-------------+| xing ming |+-------------+| K_ing || Kochhar|| De Haan|| Hunold|
+的作用
-需求：查询 first_name 和last_name 拼接成的全名，最终起别名为：姓 名
方案1：使用+ pass×
SELECT first_name+last_name AS “姓 名”
FROM employees;
方案2：使用concat拼接函数
SELECT CONCAT(first_name,last_name) AS “姓 名”
FROM employees;
mysql> select concat(first_name,last_name) as 'xing ming' from employees;+------------------+| xing ming |+------------------+| StevenK_ing|| NeenaKochhar|| LexDe Haan || AlexanderHunold || BruceErnst || DavidAustin|| ValliPataballa || DianaLorentz|| NancyGreenberg |
distinct的使用（去重）
mysql> select department_id from employees; #有重复+---------------+| department_id |+---------------+|NULL || 10 || 20 || 20 || 30 || 30 || 30 || 30 || 30 || 30 |
distinct adj. 明显的；独特的；清楚的；有区别的
查询员工涉及到的部门编号有哪些
SELECT DISTINCT department_id FROM employees;
mysql> select distinct department_id from employees; #无重复+---------------+| department_id |+---------------+|NULL || 10 || 20 || 30 || 40 || 50 || 60 || 70 || 80 || 90 || 100 || 110 |+---------------+12 rows in set (0.00 sec)
查看表的结构
DESC employees;
列 columns
SHOW COLUMNS FROM employees;
条件查询
select 查询列表
from 表名
where 筛选条件;
执行顺序：
①from子句
②where子句
③select子句
select last_name,first_name from employees where salary>20000;
按关系表达式筛选
关系运算符：> < >= <= = <> (或 != )(不等于)
mysql> select *#要查的东西-> from employees#表名-> where department_id <> 100; #条件+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate |+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| 100 | Steven| K_ing | SKING | 515.123.4567 | AD_PRES | 24000.00 | NULL | NULL | 90 | 1992-04-03 00:00:00 || 101 | Neena | Kochhar| NKOCHHAR | 515.123.4568 | AD_VP| 17000.00 | NULL | 100 | 90 | 1992-04-03 00:00:00 || 102 | Lex | De Haan| LDEHAAN | 515.123.4569 | AD_VP| 17000.00 | NULL | 100 | 90 | 1992-04-03 00:00:00 || 103 | Alexander | Hunold| AHUNOLD | 590.423.4567 | IT_PROG | 9000.00 | NULL | 102 | 60 | 1992-04-03 00:00:00 || 104 | Bruce | Ernst | BERNST | 590.423.4568 | IT_PROG | 6000.00 | NULL | 103 | 60 | 1992-04-03 00:00:00 || 105 | David | Austin| DAUSTIN | 590.423.4569 | IT_PROG | 4800.00 | NULL | 103 | 60 | 1998-03-03 00:00:00 || 106 | Valli | Pataballa | VPATABAL | 590.423.4560 | IT_PROG | 4800.00 | NULL | 103 | 60 | 1998-03-03 00:00:00 || 107 | Diana | Lorentz| DLORENTZ | 590.423.5567 | IT_PROG | 4200.00 | NULL | 103 | 60 | 1998-03-03 00:00:00 || 114 | Den | Raphaely | DRAPHEAL | 515.127.4561 | PU_MAN| 11000.00 | NULL | 100 | 30 | 2000-09-09 00:00:00 || 115 | Alexander | Khoo | AKHOO | 515.127.4562 | PU_CLERK | 3100.00 | NULL | 114 | 30 | 2000-09-09 00:00:00 || 116 | Shelli| Baida | SBAIDA | 515.127.4563 | PU_CLERK | 2900.00 | NULL | 114 | 30 | 2000-09-09 00:00:00 || 117 | Sigal | Tobias| STOBIAS | 515.127.4564 | PU_CLERK | 2800.00 | NULL | 114 | 30 | 2000-09-09 00:00:00 || 118 | Guy | Himuro| GHIMURO | 515.127.4565 | PU_CLERK | 2600.00 | NULL |
案例2：查询工资<15000的姓名、工资
mysql> select last_name,salary #要查的东西-> from employees #表名-> where salary<15000;#筛选条件+-------------+----------+| last_name | salary |+-------------+----------+| Hunold| 9000.00 || Ernst | 6000.00 || Austin| 4800.00 |
按逻辑表达式筛选
逻辑运算符：and or not 也可以使用&& || !
案例：查询奖金率>0.03 或者 员工编号在60-110之间的员工信息
mysql> select *-> from employees-> where commission_pct >0.03 or(employee_id >=60 and employee_id<=110);+-------------+-------------+------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate |+-------------+-------------+------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| 100 | Steven| K_ing| SKING | 515.123.4567 | AD_PRES | 24000.00 | NULL | NULL | 90 | 1992-04-03 00:00:00 || 101 | Neena | Kochhar | NKOCHHAR | 515.123.4568 | AD_VP| 17000.00 | NULL | 100 | 90 | 1992-04-03 00:00:00 || 102 | Lex | De Haan | LDEHAAN | 515.123.4569 | AD_VP| 17000.00 | NULL | 100 | 90 | 1992-04-03 00:00:00 || 103 | Alexander
模糊查询
like
功能：一般和通配符搭配使用，对字符型数据进行部分匹配查询
常见的通配符：
_ 任意单个字符
% 任意多个字符,支持0-多个
like/not like
案例1：查询姓名中包含字符a的员工信息
mysql> select *-> from employees-> where last_name like '%a%';+-------------+-------------+------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate |+-------------+-------------+------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| 101 | Neena | Kochhar | NKOCHHAR | 515.123.4568 | AD_VP| 17000.00 | NULL | 100 | 90 | 1992-04-03 00:00:00 || 102 | Lex | De Haan | LDEHAAN | 515.123.4569 | AD_VP| 17000.00 | NULL | 100 | 90 | 1992-04-03 00:00:00 || 105 | David | Austin| DAUSTIN | 590.423.4569 | IT_PROG | 4800.00 | NULL | 103 |
案例2：查询姓名中包含第三个字符为x的员工信息
mysql> select *-> from employees-> where last_name like '__x%';+-------------+------------+-----------+-------+--------------------+--------+---------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id | salary | commission_pct | manager_id | department_id | hiredate |+-------------+------------+-----------+-------+--------------------+--------+---------+----------------+------------+---------------+---------------------+| 170 | Tayler| Fox | TFOX | 011.44.1343.729268 | SA_REP | 9600.00 | 0.20 | 148 | 80 | -03-05 00:00:00 |+-------------+------------+-----------+-------+--------------------+--------+---------+----------------+------------+---------------+---------------------+1 row in set (0.00 sec)
案例3：查询姓名中包含第二个字符为_的员工信息
mysql> select *-> from employees-> where last_name like '_\_%';+-------------+------------+-----------+-------+--------------------+---------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id | salary | commission_pct | manager_id | department_id | hiredate |+-------------+------------+-----------+-------+--------------------+---------+----------+----------------+------------+---------------+---------------------+| 100 | Steven| K_ing| SKING | 515.123.4567 | AD_PRES | 24000.00 | NULL | NULL | 90 | 1992-04-03 00:00:00 || 156 | Janette | K_ing| JKING | 011.44.1345.429268 | SA_REP | 10000.00 | 0.35 | 146 | 80 | -03-05 00:00:00 |+-------------+------------+-----------+-------+--------------------+---------+----------+----------------+------------+---------------+---------------------+2 rows in set (0.00 sec)
SELECT *FROM employeesWHERE last_name LIKE '_$_%' ESCAPE '$'; #将￥定义为转义字符
escape
vt. 逃避，避开，避免；被忘掉；被忽视
vi. 逃脱；避开；溜走；
in
查询某字段的值是否属于指定的列表之内
a in(常量值1,常量值2,常量值3,…)
a not in(常量值1,常量值2,常量值3,…)
in/not in
案例1：查询部门编号是30/50/90的员工名、部门编号
#方式1：SELECT last_name,department_idFROM employeesWHERE department_id IN(30,50,90);#方式2：SELECT last_name,department_idFROM employeesWHERE department_id = 30OR department_id = 50OR department_id = 90;
案例2：查询工种编号不是SH_CLERK或IT_PROG的员工信息
#方式1：SELECT *FROM employeesWHERE job_id NOT IN('SH_CLERK','IT_PROG');#方式2：SELECT *FROM employeesWHERE NOT(job_id ='SH_CLERK'OR job_id = 'IT_PROG');
mysql> select *-> from employees-> where not(job_id ='SH_CLERK'-> or job_id ='IT_PROG');+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate |+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| 100 | Steven| K_ing | SKING | 515.123.4567 | AD_PRES | 24000.00 | NULL | NULL | 90 | 1992-04-03 00:00:00 || 101 | Neena | Kochhar| NKOCHHAR | 515.123.4568 | AD_VP| 17000.00 | NULL | 100 | 90 | 1992-04-03 00:00:00 || 10
between and
判断某个字段的值是否介于xx之间
between and/not between and
案例1：查询部门编号是30-90之间的部门编号、员工姓名
#方式1：SELECT department_id,last_nameFROM employeesWHERE department_id BETWEEN 30 AND 90;#方式2：SELECT department_id,last_nameFROM employeesWHERE department_id>=30 AND department_id<=90;
案例2：查询年薪不是100000-200000之间的员工姓名、工资、年薪
SELECT last_name,salary,salary*12*(1+IFNULL(commission_pct,0)) 年薪FROM employeesWHERE salary*12*(1+IFNULL(commission_pct,0))<100000 OR salary*12*(1+IFNULL(commission_pct,0))>200000;SELECT last_name,salary,salary*12*(1+IFNULL(commission_pct,0)) 年薪FROM employeesWHERE salary*12*(1+IFNULL(commission_pct,0)) NOT BETWEEN 100000 AND 200000;
mysql> SELECT last_name,salary,salary*12*(1+IFNULL(commission_pct,0))-> from employees-> WHERE salary*12*(1+IFNULL(commission_pct,0)) NOT BETWEEN 100000 AND 200000;+-------------+----------+----------------------------------------+| last_name | salary | salary*12*(1+IFNULL(commission_pct,0)) |+-------------+----------+----------------------------------------+| K_ing | 24000.00 |288000.00 || Kochhar| 17000.00 |204000.00 || De Haan| 17000.00 |204000.00 || Ernst | 6000.00 | 72000.00 || Austin| 4800.00 | 57600.00 |
is null
案例1：查询没有奖金的员工信息SELECT *FROM employeesWHERE commission_pct IS NULL;案例2：查询有奖金的员工信息SELECT *FROM employeesWHERE commission_pct IS NOT NULL;
= 只能判断普通的内容
IS 只能判断NULL值
<=> 安全等于，既能判断普通内容，又能判断NULL值
SELECT *FROM employeesWHERE salary <=> 10000;SELECT *FROM employeesWHERE commission_pct <=> NULL;
排序查询
语法：
select 查询列表
from 表名
【where 筛选条件】
order by 排序列表
顺序：
from子句where子句select子句order by 子句
(order
n. 命令；顺序；规则；订单；（生物学）目
vt. 命令；整理；订购
vi. 命令；订货)
(order by 以…排序)
特点：
排序列表可以是单个字段、多个字段、表达式、函数、列数、以及以上的组合升序 ，通过 asc ，默认行为
降序 ，通过 desc
（desc abbr. 降序排列（descend 的缩写） ）
按单个字段排序
将员工编号>120的员工信息进行工资的升序
mysql> use myemployees;Database changedmysql> select *-> from employees-> order by salary;+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate |+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| 132 | TJ| Olson | TJOLSON | 650.124.8234 | ST_CLERK | 2100.00 | NULL | 121 | 50 | -02-06 00:00:00 || 128 | Steven| Markle| SMARKLE | 650.124.1434 | ST_CLERK | 2200.00 | NULL | 120 | 50 | -02-06 00:00:00 || 136 | Hazel | Philtanker | HPHILTAN | 650.127.1634 | ST_CLERK | 2200.00 | NULL | 122 | 50 | 2002-12-23 00:00:00 || 127 | James | Landry| JLANDRY | 650.124.1334 | ST_CLERK | 2400.00 | NULL | 120 | 50 | -02-06 00:00:00 || 135 | Ki| Gee | KGEE| 650.127.1734 | ST_CLERK | 2400.00 | NULL | 122 | 50 | 2002-12-23 00:00:00 || 119 | Karen | Colmenares | KCOLMENA | 515.127.4566 | PU_CLERK | 2500.00 | NULL |
将员工编号>200的员工信息进行工资的降序
mysql> select*-> from employees-> where employee_id>200-> order by salary desc;+-------------+------------+-----------+----------+--------------+------------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate |+-------------+------------+-----------+----------+--------------+------------+----------+----------------+------------+---------------+---------------------+| 201 | Michael | Hartstein | MHARTSTE | 515.123.5555 | MK_MAN| 13000.00 | NULL | 100 | 20 | -03-03 00:00:00 || 205 | Shelley | Higgins | SHIGGINS | 515.123.8080 | AC_MGR| 12000.00 | NULL | 101 | 110 | -03-03 00:00:00 || 204 | Hermann | Baer| HBAER | 515.123.8888 | PR_REP| 10000.00 | NULL | 101 | 70 | -03-03 00:00:00 || 206 | William | Gietz| WGIETZ | 515.123.8181 | AC_ACCOUNT | 8300.00 | NULL | 205 | 110 | -03-03 00:00:00 || 203 | Susan| Mavris | SMAVRIS | 515.123.7777 | HR_REP| 6500.00 | NULL | 101 | 40 | -03-03 00:00:00 || 202 | Pat | Fay | PFAY| 603.123.6666 | MK_REP| 6000.00 | NULL | 201 | 20 | -03-03 00:00:00 |+-------------+------------+-----------+----------+--------------+------------+----------+----------------+------------+---------------+---------------------+6 rows in set (0.00 sec)
按表达式排序
对有奖金的员工，按年薪降序
IFNULL() 函数用于判断第一个表达式是否为 NULL，如果为 NULL 则返回第二个参数的值，如果不为 NULL 则返回第一个参数的值。
IFNULL() 函数语法格式为： IFNULL(expression, alt_value)
mysql> select *,salary*12*(1+ifnull(commission_pct,0))-> from employees-> where commission_pct is not null-> order by salary*12*(1+ifnull(commission_pct,0))desc;+-------------+-------------+------------+----------+--------------------+--------+----------+----------------+------------+---------------+---------------------+----------------------------------------+| employee_id | first_name | last_name | email | phone_number | job_id | salary | commission_pct | manager_id | department_id | hiredate | salary*12*(1+ifnull(commission_pct,0)) |+-------------+-------------+------------+----------+--------------------+--------+----------+----------------+------------+---------------+---------------------+----------------------------------------+| 145 | John | Russell | JRUSSEL | 011.44.1344.429268 | SA_MAN | 14000.00 | 0.40 | 100 | 80 | 2002-12-23 00:00:00 |235200.00 || 146 | Karen | Partners | KPARTNER | 011.44.1344.467268 | SA_MAN | 13500.00 | 0.30 | 100 | 80 | 2002-12-23 00:00:00 |210600.00 || 147 | Alberto| Errazuriz | AERRAZUR | 011.44.1344.429278 | SA_MAN | 12000.00 | 0.30 | 100 | 80 | 2002-12-23 00:00:00 |187200.00 || 168 | Lisa | Ozer | LOZER | 011.44.1343.929268 | SA_REP | 11500.00 | 0.25 | 148 | 80 | -03-05 00:00:00 |172500.00 || 148 | Gerald| Cambrault | GCAMBRAU | 011.44.1344.619268 | SA_MAN | 11000.00 | 0.30 | 100 | 80 | 2002-12-23 00:00:00 |171600.00 || 174 | Ellen | Abel | EABEL | 011.44.1644.429267 | SA_REP | 11000.00 | 0.30 | 149 | 80 | -03-05 00:00:00 |171600.00 || 156 | Janette| K_ing| JKING | 011.44.1345.429268 | SA_REP | 10000.00 | 0.35 | 146 | 80 | -03-05 00:00:00 |162000.00 || 162 | Clara | Vishney | CVISHNEY | 011.44.1346.129268 | SA_REP | 10500.00 | 0.25 | 147 | 80 | -03-05 00:00:00 |157500.00 || 150 | Peter | Tucker| PTUCKER | 011.44.1344.129268 | SA_REP | 10000.00 | 0.30 | 145 | 80 | -03-05 00:00:00 |156000.00 || 157 | Patrick| Sully| PSULLY | 011.44.1345.929268 | SA_REP | 9500.00 | 0.35 | 146 | 80 | -03-05 00:00:00 |153900.00 ||
按别名排序
对有奖金的员工，按年薪降序
mysql> select *,salary*12*(1+ifnull(commission_pct,0)) nianxin-> from employees-> order by nianxin desc; #此处用了重命名+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+-----------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate | nianxin |+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+-----------+| 100 | Steven| K_ing | SKING | 515.123.4567 | AD_PRES | 24000.00 | NULL | NULL | 90 | 1992-04-03 00:00:00 | 288000.00 || 145 | John | Russell| JRUSSEL | 011.44.1344.429268 | SA_MAN| 14000.00 | 0.40 | 100 | 80 | 2002-12-23 00:00:00 | 235200.00 || 146 | Karen | Partners | KPARTNER | 011.44.1344.467268 | SA_MAN| 13500.00 | 0.30 | 100
按函数的结果排序
sql中的函数模块
按姓名的字数长度进行升序
mysql> select last_name-> from employees-> order by length(last_name);+-------------+| last_name |+-------------+| Gee || Seo || Lee || Fox || Fay || Chen || Popp || Khoo |
按多个字段排序
查询员工的姓名、工资、部门编号，先按工资升序，再按部门编号降序
mysql> select last_name,salary,department_id-> from employees-> order by salary asc,department_id desc;+-------------+----------+---------------+| last_name | salary | department_id |+-------------+----------+---------------+| Olson | 2100.00 | 50 || Markle| 2200.00 | 50 || Philtanker | 2200.00 | 50 || Landry| 2400.00 | 50 || Gee | 2400.00 | 50 || Marlow| 2500.00 | 50 || Patel | 2500.00 | 50 || Vargas| 2500.00 | 50 |
按列数排序
mysql> select *-> from employees-> order by 2 desc;+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate |+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| 180 | Winston| Taylor| WTAYLOR | 650.507.9876 | SH_CLERK | 3200.00 | NULL | 120 | 50 | -03-05 00:00:00 || 171 | William| Smith | WSMITH | 011.44.1343.629268 | SA_REP| 7400.00 | 0.15 | 148 | 80 | -03-05 00:00:00 || 206 | William| Gietz | WGIETZ | 515.123.8181 | AC_ACCOUNT | 8300.00 | NULL | 205 | 110 | -03-03 00:00:00 || 195 | Vance | Jones | VJONES | 650.501.4876 | SH_CLERK | 2800.00 | NULL | 123 | 50 | -03-05 00:00:00 || 106 | V
mysql> select *-> from employees-> order by first_name;+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| employee_id | first_name | last_name | email | phone_number | job_id| salary | commission_pct | manager_id | department_id | hiredate |+-------------+-------------+-------------+----------+--------------------+------------+----------+----------------+------------+---------------+---------------------+| 121 | Adam | Fripp | AFRIPP | 650.123.2234 | ST_MAN| 8200.00 | NULL | 100 | 50 | -02-06 00:00:00 || 196 | Alana | Walsh | AWALSH | 650.507.9811 | SH_CLERK | 3100.00 | NULL | 124 | 50 | -03-05 00:00:00 || 147 | Alberto| Errazuriz | AERRAZUR | 011.44.1344.429278 | SA_MAN| 12000.00 | 0.30 | 100 | 80 | 2002-12-23 00:00:00 || 103 | Alexander | Hunold| AHUNOLD | 590.423.4567 | IT_PROG | 9000.00 | NULL | 102 | 60 | 1992-04-03 00:00:00 || 115 | Alexander | Khoo | AKHOO | 515.127.4562 | PU_CLERK | 3100.00 | NULL | 114 | 30 | 2000-09-09 00:00:00 || 185 | Alexis| Bull | ABULL | 650.509.2876 | SH_CLERK | 4100.00 | NULL | 121 | 50 | -03-05 00:00:00 || 158 | Allan | McEwen| AMCEWEN | 011.44.1345.829268 | SA_REP| 9000.00 | 0.35 | 146 | 80 | -03-05 00:00:00 || 175 | Alyssa| Hutton| AHUTTON | 011.44.1644.429266 | SA_REP| 8800.00 | 0.25 | 149 | 80 | -03-05 00:00:00 || 167 | Amit | Banda | ABANDA | 011.44.1346.729268 | SA_REP| 6200.00 | 0.10 | 147 | 80 | -03-05 00:00:00 ||
