[Nasulbad] Select

[nebulom]

Please don't move.

How can I select from a table where a certain value is on the top. Or something like the first result.

root
AnotherName
BEER
CCC
ZZZ

You should see the sample. Sorted by Asc but the root is on the top list. How do I select something like that. Thank you.

[OrdinaryFrog]

Thank you.

you're welcome

[nebulom]

Any other comments? Thank you.

[OrdinaryFrog]

Thank you.

I already said you're welcome, why do you insist

[nebulom]

[nebulom]

Thanks

[timeshifter]

you're very welcome.

[MrPolite]

you're very welcome.

[nebulom]

You guys really think I thank you?

Just an expression but never it came from my very self. Poor.

Now I sounded rude.

[dglienna]

Case sensitive "r" before "A"

[nebulom]

Say I have it on my database, Dave. Also there is a username with "a" but still I want the root to be the first result. Idea? Thanks.

[visualAd]

Please don't move.

How can I select from a table where a certain value is on the top. Or something like the first result.

root
AnotherName
BEER
CCC
ZZZ

You should see the sample. Sorted by Asc but the root is on the top list. How do I select something like that. Thank you.

Assuming that your column is called user_name:

SELECT use_rname, LCASE(user_name) sorted
    FROM table_name ORDER BY sorted;

Assuming MS SQL has a function called LCASE()

[dglienna]

VA, Are you hiding?

[nebulom]

[visualAd]

I think I don't understand your question

[NoteMe]

I think he has to do 2 selects. One to get the root out, and then one to get the rest sorted.



ØØ

[nebulom]

I want the root user to be the first result. Just the root.

root
anotheruser
otheruser
someuser

after the result (which the root first come out (should)), records are then sorted by asc, alphabetically. NotKLH is right putting a whitespace or a special character on the root user but the root has to enter [special character]root on the login form.

[nebulom]

I think he has to do 2 selects. One to get the root out, and then one to get the rest sorted.



ØØ

Yeah. I think I'll have to do it this way.

Or... I have a date column and set 1/1/01 for root and select order by date.

[visualAd]

I want the root user to be the first result. Just the root.

root
anotheruser
otheruser
someuser

after the result (which the root first come out (should)), records are then sorted by asc, alphabetically. NotKLH is right putting a whitespace or a special character on the root user but the root has to enter [special character]root on the login form.

Ahhh, well make an extra column called importance. Give root an importance of 0 and everything else an importance of 1 and use this query:

SELECT username, importance
    FROM [user]
    ORDER BY importance, username;

[nebulom]

Usa ka sa mga maayo nga mga programmer nga akong nahimamat. Salamat.