Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help needed with weird select
Lets say I have 1000 products and want to return the product id, product name, ordered by product name ascending, and (here is the weird part) I also want to return the first instance of each letter of the alphabet from the product name's first character. Kind of like this:
product id product-name first instance of letter ----------- -------------- ----------------------- 1 apple pie a 2 aspirin 3 coffee c 4 ground beef g 5 gumetc ..
How would this be done if it's even possible? Thanks
-- To reply directly, replace the zero in my email address with the letter e.Received on Fri Dec 22 2000 - 12:56:48 CST