Displaying employee records for a selected department and rate
Example1
| Department |
Name |
Hourly Rate |
Programming Language |
Department =
"Sales"
and hourly rate >
"40"
| Sales |
Bill Ratford |
85 |
COBOL |
| Sales |
Bill Snakeson |
95 |
HTML |
Example2
| Department |
Name |
Hourly Rate |
Programming Language |
Department =
"Internet"
and hourly rate >
"20"
| Internet |
John Smith |
25 |
VB |
| Internet |
Richard Manning |
150 |
XML |
| Internet |
Jessy Hammonds |
120 |
XSL |
| Internet |
Dennis Hammer |
50 |
HTML |
| Internet |
Walter Duncan |
40 |
ASP |
| Internet |
Mark Donalds |
100 |
XML |