-
mysql> SELECT f_name, l_name, age from
-> employee_data ORDER BY age
-> LIMIT 5;
+---------+----------+------+
| f_name | l_name | age |
+---------+----------+------+
| Edward | Sakamuro | 25 |
| Mary | Anchor | 26 |
| Anamika | Pandit | 27 |
| Hal | Simlai | 27 |
| Joseph | Irvine | 27 |
+---------+----------+------+
5 rows in set (0.00 sec)
-
mysql> SELECT * from employee_data
-> LIMIT 10, 5;
+--------+--------+--------+-----------------------+------+------+--------+-------+-------------------+
| emp_id | f_name | l_name | title | age | yos | salary | perks | email |
+--------+--------+--------+-----------------------+------+------+--------+-------+-------------------+
| 11 | Paul | Simon | Multimedia Programmer | 43 | 2 | 85000 | 12000 | ps@bignet.com |
| 12 | Arthur | Hoopla | Multimedia Programmer | 32 | 1 | 75000 | 15000 | arthur@bignet.com |
| 13 | Kim | Hunter | Senior Web Designer | 32 | 2 | 110000 | 20000 | kim@bignet.com |
| 14 | Roger | Lewis | System Administrator | 35 | 2 | 100000 | 13000 | roger@bignet.com |
| 15 | Danny | Gibson | System Administrator | 34 | 1 | 90000 | 12000 | danny@bignet.com |
+--------+--------+--------+-----------------------+------+------+--------+-------+-------------------+
5 rows in set (0.00 sec)
-
mysql> select f_name, l_name, salary
-> from employee_data
-> ORDER BY salary DESC
-> LIMIT 1;
+--------+--------+--------+
| f_name | l_name | salary |
+--------+--------+--------+
| Manish | Sharma | 200000 |
+--------+--------+--------+
1 row in set (0.01 sec)
- This lists the id, age and perks of 10 employees who draw the largest perks.
mysql> SELECT emp_id, age, perks
-> from employee_data ORDER BY
-> perks DESC LIMIT 10;
+--------+------+-------+
| emp_id | age | perks |
+--------+------+-------+
| 1 | 28 | 50000 |
| 16 | 36 | 28000 |
| 2 | 32 | 25000 |
| 17 | 30 | 25000 |
| 21 | 36 | 25000 |
| 3 | 32 | 20000 |
| 13 | 32 | 20000 |
| 18 | 27 | 18000 |
| 19 | 27 | 18000 |
| 7 | 34 | 16000 |
+--------+------+-------+
10 rows in set (0.01 sec)