Skip to content

Instantly share code, notes, and snippets.

@Capncavedan

Capncavedan/gist:3176635

Created July 25, 2012 15:03
Show Gist options
  • Save Capncavedan/3176635 to your computer and use it in GitHub Desktop.
Save Capncavedan/3176635 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select * from types_of_work where id < 10 order by bond_category limit 9;
+----+------------+-------------------+-----------------------------+---------------+------+
| id | rate_class | general_type | specific_type | bond_category | code |
+----+------------+-------------------+-----------------------------+---------------+------+
| 3 | A | All Other Class A | Airports - site preparation | 1 | 49 |
| 5 | A | All Other Class A | Airports - site preparation | 2 | 49 |
| 1 | A | All Other Class A | Airports - site preparation | 3 | 49 |
| 2 | A | All Other Class A | Airports - site preparation | 4 | 49 |
| 4 | A | All Other Class A | Airports - site preparation | 5 | 49 |
| 7 | A | All Other Class A | Airports - site preparation | 6 | 49 |
| 6 | A | All Other Class A | Airports - site preparation | 7 | 49 |
| 8 | A | All Other Class A | Airports - site preparation | Flat | 49 |
| 9 | A | All Other Class A | Airports - site preparation | Pref II | 49 |
+----+------------+-------------------+-----------------------------+---------------+------+
9 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment