Basic SQL Example

Switch to Table format

Return to the Net.Data Examples

SELECT cat, subcat, prdnam FROM ignsql.bcbkinv2 order by prdnam,subcat, cat for fetch only

 CAT   | SUBCAT     | PRDNAM                   |
------------------------------------------------
 Fruit | Citrus     | çilek                    |
------------------------------------------------
 Fruit | Papaya     | aaaaaaaaaaaaaaaaaaaaaaa  |
------------------------------------------------
 Fruit | Apples     | aasa                     |
------------------------------------------------
 Fruit | Apples     | adfdsafads               |
------------------------------------------------
 Fruit | Apples     | annick                   |
------------------------------------------------
 Fruit | Apples     | apples - purple          |
------------------------------------------------
 Fruit | Apples     | asdfasdf                 |
------------------------------------------------
 Fruit | Avacados   | ava                      |
------------------------------------------------
 Fruit | Melons     | ave                      |
------------------------------------------------
 Fruit | Mango      | banannnannnassss         |
------------------------------------------------
 Fruit | Apples     | bilberry                 |
------------------------------------------------
 Fruit | Avacados   | cvvxv                    |
------------------------------------------------
 Fruit | Apples     | dfdfd                    |
------------------------------------------------
 Fruit | Citrus     | fghfgh                   |
------------------------------------------------
 Fruit | Pears      | fred pear                |
------------------------------------------------
 Fruit | Apples     | gggggg                   |
------------------------------------------------
 Fruit | Apples     | juicy fruit              |
------------------------------------------------
 Fruit | Apples     | limon acido              |
------------------------------------------------
 Fruit | Apples     | lkjf                     |
------------------------------------------------
 Fruit | Apples     | papapapapap yaaa         |
------------------------------------------------
 Fruit | Avacados   | prod name                |
------------------------------------------------
 Fruit | Citrus     | sour apples              |
------------------------------------------------
 Fruit | Mango      | strange fruit            |
------------------------------------------------
 Fruit | Apples     | test                     |
------------------------------------------------
 Fruit | Citrus     | test                     |
------------------------------------------------
 Fruit | Avacados   | test fruit avacados      |
------------------------------------------------
 Fruit | Apples     | teste                    |
------------------------------------------------
 Fruit | Papaya     | testing                  |
------------------------------------------------
 Fruit | Apples     | yyyyyyy                  |
------------------------------------------------
 Fruit | Apples     | A Large Melon            |
------------------------------------------------
 Fruit | Apples     | Ananas                   |
------------------------------------------------
 Fruit | Citrus     | Bakersfield Crenshaws    |
------------------------------------------------
 Fruit | Apples     | Bert                     |
------------------------------------------------
 Fruit | Avacados   | Big Blueberries          |
------------------------------------------------
 Fruit | Melons     | Bing Crosby              |
------------------------------------------------
 Fruit | Grapes     | Black Satin BerryBerry   |
------------------------------------------------
 Fruit | Grapes     | Blue Grape               |
------------------------------------------------
 Fruit | Melons     | Blueberrie D7elight      |
------------------------------------------------
 Fruit | Avacados   | Braeburn added added     |
------------------------------------------------
 Fruit | Apples     | BUGGERS bedlam           |
------------------------------------------------
 Fruit | Citrus     | Computer berries         |
------------------------------------------------
 Fruit | Apples     | CAN PET                  |
------------------------------------------------
 Fruit | Citrus     | CITRUS                   |
------------------------------------------------
 Fruit | Melons     | D'Anjou                  |
------------------------------------------------
 Fruit | Apples     | Dan's Beauty             |
------------------------------------------------
 Fruit | Apples     | Dead                     |
------------------------------------------------
 Fruit | Avacados   | DJR                      |
------------------------------------------------
 Fruit | Apples     | DOG TAIL                 |
------------------------------------------------
 Fruit | Peaches    | Elegent Lady             |
------------------------------------------------
 Fruit | Avacados   | Epler & Pærer            |
------------------------------------------------
 Fruit | Citrus     | Florida Navel Orange     |
------------------------------------------------
 Fruit | Citrus     | Fresh stuff              |
------------------------------------------------
 Fruit | Melons     | Fresno Watermelons       |
------------------------------------------------
 Fruit | Avacados   | Fruit Loops              |
------------------------------------------------
 Fruit | Avacados   | Fugazi                   |
------------------------------------------------
 Fruit | Apples     | Georgia Peach            |
------------------------------------------------
 Fruit | Peaches    | Georgia Plums            |
------------------------------------------------
 Fruit | Grapes     | Goofy Grape              |
------------------------------------------------
 Fruit | Melons     | Honeydew                 |
------------------------------------------------
 Fruit | Peaches    | Joe's Peaches            |
------------------------------------------------
 Fruit | Peaches    | KiWi                     |
------------------------------------------------
 Fruit | Nectarines | Majic Special Nectarines |
------------------------------------------------
 Fruit | Mango      | Mango                    |
------------------------------------------------
 Fruit | Avacados   | My Avocados              |
------------------------------------------------
 Fruit | Melons     | My Melons                |
------------------------------------------------
 Fruit | Avacados   | MAÇA                     |
------------------------------------------------
 Fruit | Apples     | No Mango                 |
------------------------------------------------
 Fruit | Avacados   | Orange type of apples    |
------------------------------------------------
 Fruit | Papaya     | Papaya                   |
------------------------------------------------
 Fruit | Citrus     | Passionfruit             |
------------------------------------------------
 Fruit | Nectarines | Peaches                  |
------------------------------------------------
 Fruit | Apples     | Peaching Peaches         |
------------------------------------------------
 Fruit | Apples     | Pears -ANJOIU            |
------------------------------------------------
 Fruit | Pinapples  | Pinapple                 |
------------------------------------------------
 Fruit | Mango      | Pinapples Blu            |
------------------------------------------------
 Fruit | Apples     | Pomme d'api              |
------------------------------------------------
 Fruit | Apples     | Raw                      |
------------------------------------------------
 Fruit | Citrus     | Red D'Anjou              |
------------------------------------------------
 Fruit | Avacados   | Red Delicious            |
------------------------------------------------
 Fruit | Mango      | Red Delicious            |
------------------------------------------------
 Fruit | Grapes     | Red Flame                |
------------------------------------------------
 Fruit | Citrus     | Red Raspberries          |
------------------------------------------------
 Fruit | Avacados   | Reinaldo Blueberries     |
------------------------------------------------
 Fruit | Pears      | Rock Pear                |
------------------------------------------------
 Fruit | Avacados   | Sergey Test #1           |
------------------------------------------------
 Fruit | Apples     | Shirley                  |
------------------------------------------------
 Fruit | Papaya     | Strawberry Papaya        |
------------------------------------------------
 Fruit | Citrus     | Super Berries - Portugal |
------------------------------------------------
 Fruit | Pinapples  | Swellendam               |
------------------------------------------------
 Fruit | Melons     | Tastee Juice Apples      |
------------------------------------------------
 Fruit | Apples     | Test                     |
------------------------------------------------
 Fruit | Apples     | Test                     |
------------------------------------------------
 Fruit | Apples     | Test de ajut400.com      |
------------------------------------------------
 Fruit | Apples     | Test item                |
------------------------------------------------
 Fruit | Mango      | This really works-NEW    |
------------------------------------------------
 Fruit | Avacados   | This was a Test          |
------------------------------------------------
 Fruit | Grapes     | Thomson Seedles          |
------------------------------------------------
 Fruit | Melons     | Water Melon              |
------------------------------------------------
 Fruit | Melons     | Watermelons              |
------------------------------------------------
 Fruit | Grapes     | Winesap                  |
------------------------------------------------
 Fruit | Apples     | 111                      |
------------------------------------------------
 Fruit | Apples     | 111                      |
------------------------------------------------
 Fruit | Grapes     | 1234                     |
------------------------------------------------
 Fruit | Apples     | 547                      |
------------------------------------------------