Archive for September 23rd, 2009
Answering questions asked on the site.
I want to build an alphabetical index over the articles in my database.
I need to show 5 entries in the index, like this:
E-Fetc., so that each entry contains roughly equal number of articles.
How do I do it in a single query?
This is in Oracle
This is a good task to demonstrate Oracle‘s analytic abilities.
To do this, we will create a sample table:
Read the rest of this entry »