Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.45-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use basesm;
Database changed
mysql> create table empleados(idt integer, apellido varchar(20),oficio varchar (
20),direccion integer,fechaALT date,salario integer,comision integer,Ndept integ
er,primary key(idt));
Query OK, 0 rows affected (0.19 sec)
mysql>
mysql> insert into empleados values(7369,'sanchez','empleado',7902,17/12/1980,10
4000,0,20);
Query OK, 1 row affected (0.10 sec)
mysql> insert into empleados values(7499,'arroyo','vendedor',7696,20/02/1980,208
000,39000,30);
Query OK, 1 row affected (0.05 sec)
mysql> insert into empleados values(7521,'sala','vendedor',7698,22/02/1981,16250
0,0,30);
Query OK, 1 row affected (0.10 sec)
mysql> insert into empleados values(7566,'jimenez','director',7839,02/04/1981,38
6750,0,20);
Query OK, 1 row affected (0.05 sec)
mysql> insert into empleados values(7654,'martin','vendedor',7698,29/09/1981,162
500,182000,30);
Query OK, 1 row affected (0.06 sec)
mysql> insert into empleados values(7696,'negro','director',7839,01/05/1981,3705
00,0,30);
Query OK, 1 row affected (0.11 sec)
mysql> insert into empleados values(7788,'gil','analista',7555,09/11/1981,390000
,0,20);
Query OK, 1 row affected (0.08 sec)
mysql> insert into empleados values(7839,'rey','presidente',0,17/11/1981,650000,
0,10);
Query OK, 1 row affected (0.04 sec)
mysql> insert into empleados values(7844,'tovar','vendedor',7698,08/09/1981,1950
00,0,30);
Query OK, 1 row affected (0.04 sec)
mysql> insert into empleados values(7876,'alonso','empleado',7788,23/09/1981,143
000,0,20);
Query OK, 1 row affected (0.05 sec)
mysql> insert into empleados values(7900,'jimeno','empleado',7698,03/12/1981,123
5000,0,30);
Query OK, 1 row affected (0.07 sec)
mysql> insert into empleados values(7902,'fernandez','analista',7655,03/12/1981,
390000,0,20);
Query OK, 1 row affected (0.06 sec)
mysql> insert into empleados values(7934,'muños','empleado',7782,23/01/1982,1690
00,0,10);
Query OK, 1 row affected (0.04 sec)
mysql> select*from empleados;
+------+-----------+------------+-----------+------------+---------+----------+-
------+
| idt | apellido | oficio | direccion | fechaALT | salario | comision |
Ndept |
+------+-----------+------------+-----------+------------+---------+----------+-
------+
| 7369 | sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 |
20 |
| 7499 | arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 |
30 |
| 7521 | sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 |
30 |
| 7566 | jimenez | director | 7839 | 0000-00-00 | 386750 | 0 |
20 |
| 7654 | martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 |
30 |
| 7696 | negro | director | 7839 | 0000-00-00 | 370500 | 0 |
30 |
| 7788 | gil | analista | 7555 | 0000-00-00 | 390000 | 0 |
20 |
| 7839 | rey | presidente | 0 | 0000-00-00 | 650000 | 0 |
10 |
| 7844 | tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 |
30 |
| 7876 | alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 |
20 |
| 7900 | jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 |
30 |
| 7902 | fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 |
20 |
| 7934 | muños | empleado | 7782 | 0000-00-00 | 169000 | 0 |
10 |
+------+-----------+------------+-----------+------------+---------+----------+-
------+
13 rows in set (0.00 sec)
mysql> create table departamento(idt integer, nombreD varchar(20),LOC varchar (2
0),primary key(idt));
Query OK, 0 rows affected (0.11 sec)
mysql> insert into empleados values(10,'contabiladad','sevilla');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into departamento values(10,'contabiladad','sevilla');
Query OK, 1 row affected (0.06 sec)
mysql> insert into departamento values(20,'investigacion','madrid');
Query OK, 1 row affected (0.07 sec)
mysql> insert into departamento values(30,'ventas','barcelona');
Query OK, 1 row affected (0.05 sec)
mysql> insert into departamento values(40,'produccion','bilbao');
Query OK, 1 row affected (0.05 sec)
mysql> select*from departamento;
+-----+---------------+-----------+
| idt | nombreD | LOC |
+-----+---------------+-----------+
| 10 | contabiladad | sevilla |
| 20 | investigacion | madrid |
| 30 | ventas | barcelona |
| 40 | produccion | bilbao |
+-----+---------------+-----------+
4 rows in set (0.00 sec)
mysql>
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 |
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 |
+-----------+------------+-----------+------------+---------+----------+
13 rows in set (0.00 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados ORDER BY apellido;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.02 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados ORDER BY Ndept ;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados ORDER BY
-> Ndept DESC;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados ORDER BY apellido,Ndept DESC;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados
-> ORDER BY apellido, Ndept DESC;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,Ndept FROM empleados
-> ORDER BY apellido, Ndept DESC;
+-----------+-------+
| apellido | Ndept |
+-----------+-------+
| alonso | 20 |
| arroyo | 30 |
| fernandez | 20 |
| gil | 20 |
| jimenez | 20 |
| jimeno | 30 |
| martin | 30 |
| muños | 10 |
| negro | 30 |
| rey | 10 |
| sala | 30 |
| sanchez | 20 |
| tovar | 30 |
+-----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,Ndept FROM empleados
-> ORDER BY apellido,Ndept DESC;
+-----------+-------+
| apellido | Ndept |
+-----------+-------+
| alonso | 20 |
| arroyo | 30 |
| fernandez | 20 |
| gil | 20 |
| jimenez | 20 |
| jimeno | 30 |
| martin | 30 |
| muños | 10 |
| negro | 30 |
| rey | 10 |
| sala | 30 |
| sanchez | 20 |
| tovar | 30 |
+-----------+-------+
13 rows in set (0.00 sec)
mysql>
se
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados ORDER BY
-> Ndept DESC;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados ORDER BY apellido,Ndept DESC;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,oficio,direccion,fechaALT,salario,comision,Ndept from emp
leados
-> ORDER BY apellido, Ndept DESC;
+-----------+------------+-----------+------------+---------+----------+-------+
| apellido | oficio | direccion | fechaALT | salario | comision | Ndept |
+-----------+------------+-----------+------------+---------+----------+-------+
| alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 | 20 |
| arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 | 30 |
| fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 | 20 |
| gil | analista | 7555 | 0000-00-00 | 390000 | 0 | 20 |
| jimenez | director | 7839 | 0000-00-00 | 386750 | 0 | 20 |
| jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 | 30 |
| martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 | 30 |
| muños | empleado | 7782 | 0000-00-00 | 169000 | 0 | 10 |
| negro | director | 7839 | 0000-00-00 | 370500 | 0 | 30 |
| rey | presidente | 0 | 0000-00-00 | 650000 | 0 | 10 |
| sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 | 30 |
| sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 | 20 |
| tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 | 30 |
+-----------+------------+-----------+------------+---------+----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,Ndept FROM empleados
-> ORDER BY apellido, Ndept DESC;
+-----------+-------+
| apellido | Ndept |
+-----------+-------+
| alonso | 20 |
| arroyo | 30 |
| fernandez | 20 |
| gil | 20 |
| jimenez | 20 |
| jimeno | 30 |
| martin | 30 |
| muños | 10 |
| negro | 30 |
| rey | 10 |
| sala | 30 |
| sanchez | 20 |
| tovar | 30 |
+-----------+-------+
13 rows in set (0.00 sec)
mysql> select apellido,Ndept FROM empleados
-> ORDER BY apellido,Ndept DESC;
+-----------+-------+
| apellido | Ndept |
+-----------+-------+
| alonso | 20 |
| arroyo | 30 |
| fernandez | 20 |
| gil | 20 |
| jimenez | 20 |
| jimeno | 30 |
| martin | 30 |
| muños | 10 |
| negro | 30 |
| rey | 10 |
| sala | 30 |
| sanchez | 20 |
| tovar | 30 |
+-----------+-------+
13 rows in set (0.00 sec)
mysql> SELECT* FROM empleados WHERE salario >=2000000;
Empty set (0.00 sec)
mysql> SELECT* FROM empleados WHERE salario >=143000;
+------+-----------+------------+-----------+------------+---------+----------+-
------+
| idt | apellido | oficio | direccion | fechaALT | salario | comision |
Ndept |
+------+-----------+------------+-----------+------------+---------+----------+-
------+
| 7499 | arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 |
30 |
| 7521 | sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 |
30 |
| 7566 | jimenez | director | 7839 | 0000-00-00 | 386750 | 0 |
20 |
| 7654 | martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 |
30 |
| 7696 | negro | director | 7839 | 0000-00-00 | 370500 | 0 |
30 |
| 7788 | gil | analista | 7555 | 0000-00-00 | 390000 | 0 |
20 |
| 7839 | rey | presidente | 0 | 0000-00-00 | 650000 | 0 |
10 |
| 7844 | tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 |
30 |
| 7876 | alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 |
20 |
| 7900 | jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 |
30 |
| 7902 | fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 |
20 |
| 7934 | muños | empleado | 7782 | 0000-00-00 | 169000 | 0 |
10 |
+------+-----------+------------+-----------+------------+---------+----------+-
------+
12 rows in set (0.00 sec)
mysql> SELECT* FROM empleados WHERE oficio ='analista';
+------+-----------+----------+-----------+------------+---------+----------+---
----+
| idt | apellido | oficio | direccion | fechaALT | salario | comision | Nd
ept |
+------+-----------+----------+-----------+------------+---------+----------+---
----+
| 7788 | gil | analista | 7555 | 0000-00-00 | 390000 | 0 |
20 |
| 7902 | fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 |
20 |
+------+-----------+----------+-----------+------------+---------+----------+---
----+
2 rows in set (0.02 sec)
mysql> select apellido,oficio FROM empleados WHERE Ndept=20;
+-----------+----------+
| apellido | oficio |
+-----------+----------+
| sanchez | empleado |
| jimenez | director |
| gil | analista |
| alonso | empleado |
| fernandez | analista |
+-----------+----------+
5 rows in set (0.00 sec)
mysql> select apellido from empleados ORDER BY apellido;
+-----------+
| apellido |
+-----------+
| alonso |
| arroyo |
| fernandez |
| gil |
| jimenez |
| jimeno |
| martin |
| muños |
| negro |
| rey |
| sala |
| sanchez |
| tovar |
+-----------+
13 rows in set (0.00 sec)
mysql>
mysql> select*from departamento;
+-----+---------------+-----------+
| idt | nombreD | LOC |
+-----+---------------+-----------+
| 10 | contabiladad | sevilla |
| 20 | investigacion | madrid |
| 30 | ventas | barcelona |
| 40 | produccion | bilbao |
+-----+---------------+-----------+
4 rows in set (0.00 sec)
mysql> SELECT* FROM empleados WHERE oficio='vendedor';
+------+----------+----------+-----------+------------+---------+----------+----
---+
| idt | apellido | oficio | direccion | fechaALT | salario | comision | Nde
pt |
+------+----------+----------+-----------+------------+---------+----------+----
---+
| 7499 | arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 |
30 |
| 7521 | sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 |
30 |
| 7654 | martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 |
30 |
| 7844 | tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 |
30 |
+------+----------+----------+-----------+------------+---------+----------+----
---+
4 rows in set (0.03 sec)
mysql> select apellido,oficio from empleados WHERE oficio='vendedor' ORDER BY ap
ellido;
+----------+----------+
| apellido | oficio |
+----------+----------+
| arroyo | vendedor |
| martin | vendedor |
| sala | vendedor |
| tovar | vendedor |
+----------+----------+
4 rows in set (0.02 sec)
mysql> SELECT* FROM empleados WHERE Ndept=10 AND oficio='analista' ORDER BY apel
lido;
Empty set (0.03 sec)
mysql> SELECT* FROM empleados WHERE salario>=2000000 AND Ndept=20;
Empty set (0.03 sec)
mysql> SELECT* FROM empleados WHERE Ndept=20;
+------+-----------+----------+-----------+------------+---------+----------+---
----+
| idt | apellido | oficio | direccion | fechaALT | salario | comision | Nd
ept |
+------+-----------+----------+-----------+------------+---------+----------+---
----+
| 7369 | sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 |
20 |
| 7566 | jimenez | director | 7839 | 0000-00-00 | 386750 | 0 |
20 |
| 7788 | gil | analista | 7555 | 0000-00-00 | 390000 | 0 |
20 |
| 7876 | alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 |
20 |
| 7902 | fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 |
20 |
+------+-----------+----------+-----------+------------+---------+----------+---
----+
5 rows in set (0.00 sec)
mysql> SELECT* FROM empleados WHERE salario>=200000 AND Ndept=20;
+------+-----------+----------+-----------+------------+---------+----------+---
----+
| idt | apellido | oficio | direccion | fechaALT | salario | comision | Nd
ept |
+------+-----------+----------+-----------+------------+---------+----------+---
----+
| 7566 | jimenez | director | 7839 | 0000-00-00 | 386750 | 0 |
20 |
| 7788 | gil | analista | 7555 | 0000-00-00 | 390000 | 0 |
20 |
| 7902 | fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 |
20 |
+------+-----------+----------+-----------+------------+---------+----------+---
----+
3 rows in set (0.00 sec)
mysql> select oficio from empleados WHERE oficio='nombre' ORDER BY oficio;
Empty set (0.00 sec)
mysql> select oficio from empleados ORDER BY oficio;
+------------+
| oficio |
+------------+
| analista |
| analista |
| director |
| director |
| empleado |
| empleado |
| empleado |
| empleado |
| presidente |
| vendedor |
| vendedor |
| vendedor |
| vendedor |
+------------+
13 rows in set (0.00 sec)
mysql> SELECT* FROM empleados WHERE apellido='a';
Empty set (0.00 sec)
mysql> select apellido from empleados WHERE apellido='a';
Empty set (0.00 sec)
mysql> select apellido from empleados ORDER BY 'a';
+-----------+
| apellido |
+-----------+
| sanchez |
| arroyo |
| sala |
| jimenez |
| martin |
| negro |
| gil |
| rey |
| tovar |
| alonso |
| jimeno |
| fernandez |
| muños |
+-----------+
13 rows in set (0.00 sec)
mysql> SELECT* FROM empleados WHERE oficio='vendedor' AND comision>=100000;
+------+----------+----------+-----------+------------+---------+----------+----
---+
| idt | apellido | oficio | direccion | fechaALT | salario | comision | Nde
pt |
+------+----------+----------+-----------+------------+---------+----------+----
---+
| 7654 | martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 |
30 |
+------+----------+----------+-----------+------------+---------+----------+----
---+
1 row in set (0.00 sec)
mysql> select* from empleados ORDER BY apellido,Ndept;
+------+-----------+------------+-----------+------------+---------+----------+-
------+
| idt | apellido | oficio | direccion | fechaALT | salario | comision |
Ndept |
+------+-----------+------------+-----------+------------+---------+----------+-
------+
| 7876 | alonso | empleado | 7788 | 0000-00-00 | 143000 | 0 |
20 |
| 7499 | arroyo | vendedor | 7696 | 0000-00-00 | 208000 | 39000 |
30 |
| 7902 | fernandez | analista | 7655 | 0000-00-00 | 390000 | 0 |
20 |
| 7788 | gil | analista | 7555 | 0000-00-00 | 390000 | 0 |
20 |
| 7566 | jimenez | director | 7839 | 0000-00-00 | 386750 | 0 |
20 |
| 7900 | jimeno | empleado | 7698 | 0000-00-00 | 1235000 | 0 |
30 |
| 7654 | martin | vendedor | 7698 | 0000-00-00 | 162500 | 182000 |
30 |
| 7934 | muños | empleado | 7782 | 0000-00-00 | 169000 | 0 |
10 |
| 7696 | negro | director | 7839 | 0000-00-00 | 370500 | 0 |
30 |
| 7839 | rey | presidente | 0 | 0000-00-00 | 650000 | 0 |
10 |
| 7521 | sala | vendedor | 7698 | 0000-00-00 | 162500 | 0 |
30 |
| 7369 | sanchez | empleado | 7902 | 0000-00-00 | 104000 | 0 |
20 |
| 7844 | tovar | vendedor | 7698 | 0000-00-00 | 195000 | 0 |
30 |
+------+-----------+------------+-----------+------------+---------+----------+-
------+
13 rows in set (0.00 sec)
mysql> select oficio from empleados WHERE oficio='empleado'AND salario>=100000 A
ND Ndept=10;
+----------+
| oficio |
+----------+
| empleado |
+----------+
1 row in set (0.00 sec)
mysql> select oficio,salario,Ndept from empleados WHERE oficio='empleado'AND sal
ario>=100000 AND Ndept=10;
+----------+---------+-------+
| oficio | salario | Ndept |
+----------+---------+-------+
| empleado | 169000 | 10 |
+----------+---------+-------+
1 row in set (0.00 sec)
mysql> select apellido, oficio,salario,Ndept from empleados WHERE oficio='emplea
do'AND salario>=100000 AND Ndept=10;
+----------+----------+---------+-------+
| apellido | oficio | salario | Ndept |
+----------+----------+---------+-------+
| muños | empleado | 169000 | 10 |
+----------+----------+---------+-------+
1 row in set (0.00 sec)
11 rows in set (0.00 sec)
mysql> select apellido,comision,oficio from empleados WHERE comision=0;
+-----------+----------+------------+
| apellido | comision | oficio |
+-----------+----------+------------+
| sanchez | 0 | empleado |
| sala | 0 | vendedor |
| jimenez | 0 | director |
| negro | 0 | director |
| gil | 0 | analista |
| rey | 0 | presidente |
| tovar | 0 | vendedor |
| alonso | 0 | empleado |
| jimeno | 0 | empleado |
| fernandez | 0 | analista |
| muños | 0 | empleado |
+-----------+----------+------------+
11 rows in set (0.00 sec)
mysql> select apellido from empleados WHERE salario between '100000' AND '20000
0';
+----------+
| apellido |
+----------+
| sanchez |
| sala |
| martin |
| tovar |
| alonso |
| muños |
+----------+
6 rows in set (0.03 sec)
mysql> select apellido,salario from empleados WHERE salario between '100000' AN
D '200000';
+----------+---------+
| apellido | salario |
+----------+---------+
| sanchez | 104000 |
| sala | 162500 |
| martin | 162500 |
| tovar | 195000 |
| alonso | 143000 |
| muños | 169000 |
+----------+---------+
6 rows in set (0.00 sec)
mysql> select apellido,salario from empleados WHERE salario between '100000' AN
D '200000' ORDER BY salario,apellido;
+----------+---------+
| apellido | salario |
+----------+---------+
| sanchez | 104000 |
| alonso | 143000 |
| martin | 162500 |
| sala | 162500 |
| muños | 169000 |
| tovar | 195000 |
+----------+---------+
6 rows in set (0.00 sec)
No hay comentarios:
Publicar un comentario