sql alternate result set

[stevebooks]

Hello,

Was wondering if anyone knew how to do a sql select that will alternate a result set.

For example,

I have a table called account and in account I have two different seller types 'I' and 'D'. After I run a sql query I want an 'I' record to show up and then a 'D' record and then 'I', etc....

Thanks!

 

[r937]

not easily

i can think of one way to do it which involves two temporary tables with auto_increments and a UNION query

what's this for?

r937.com | rudy.ca

 

[guelphdad]

i would use php or some other application and still it wouldn't be all that simple.

 

[stevebooks]

Yea, I am doing a website and using cgi/perl. I wanted to do one sql select statement, but I ended up doing two sql statements, and then via code I re-organized the results.


Thanks for the help!