Example of database query
This is a database table.
Rec # | Field1 | Field2 | Field3 |
---|---|---|---|
1 | Paul | Johnson | 450 |
2 | George | Brown | 335 |
3 | Paul | Gray | 845 |
4 | Tom | Young | 335 |
5 | Tom | Sanders | 400 |
Given the table above, what would be the resulting table for this query?
Field1 |
---|
Paul |
Given the table above, what would be the resulting table for this query?
Field1 | Field3 |
---|---|
George | |
>400 |
Given the table above, what would be the resulting table for this query?
Field1 | Field3 |
---|---|
Tom | <375 |