[Nasulbad] Select

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. :cry:

Quote:

---

Originally Posted by nebulom

Thank you. :cry:

---

you're welcome

Any other comments? Thank you. :cry:

Quote:

---

Originally Posted by nebulom

Thank you. :cry:

---

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

:rolleyes:

Thanks

you're very welcome.:eek2:

Quote:

---

Originally Posted by timeshifter

you're very welcome.:eek2:

---

:lol:

You guys really think I thank you?

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

Now I sounded rude. :cry:

Case sensitive "r" before "A"

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.

Quote:

---

Originally Posted by 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. :cry:

---

Assuming that your column is called user_name:

Code:

---

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

---

Assuming MS SQL has a function called LCASE() ;)

VA, Are you hiding?

:cry:

Quote:

---

Originally Posted by nebulom

:cry:

---

I think I don't understand your question :confused:

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



ØØ

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.

Quote:

---

Originally Posted by NoteMe

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. :sick:

Quote:

---

Originally Posted by 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.

---

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:

Code:

---

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

---

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