Basic SQL Example

Switch to Text 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