I need help designing a SQL Query.
I need to find all distinct MODULENAME's with the latest REVISION_ID and exclude the ones that have an empty/null CONTENT column.
REVISION_ID is a auto-incrementing primary key.
There will be many more MODULENAME's other than Front_Page normally.
Here's a screenshot of my table so you can make more sense of what I am talking about:
If I am making no sense at all, please say so!
Just give me solution in whatever flavor of SQL you use and I will work from that. I cant get my brain around how to write this one out!
Edit: Heres CREATE TABLE
I need to find all distinct MODULENAME's with the latest REVISION_ID and exclude the ones that have an empty/null CONTENT column.
REVISION_ID is a auto-incrementing primary key.
There will be many more MODULENAME's other than Front_Page normally.
Here's a screenshot of my table so you can make more sense of what I am talking about:

If I am making no sense at all, please say so!
Just give me solution in whatever flavor of SQL you use and I will work from that. I cant get my brain around how to write this one out!
Edit: Heres CREATE TABLE
Code:
CREATE TABLE content (
revision_id INTEGER NOT NULL,
modulename VARCHAR(256),
content VARCHAR(102400),
summary VARCHAR(256),
created TIMESTAMP,
PRIMARY KEY (revision_id)
)
Last edited: