Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

my sql problem

Comment:

can I have certain row of a table first in my "select * from any table". eg. suppose I have a table name 'student' with fields id and name. ids are 1,2,3,4,5 and names are a,b,c,d,e. I want to get result as the name = b should be in first row of the result always number of ids and names may increase.

Reply:

Your "question" doesn't make sense. Please rephrase your question.

0

Reply:

I'll assume you want this: select * from any table order by ID_COLUMN asc; Hi there.

0

Reply:

Apologies if this is way off the mark, but I think what you want can be achieved with: SELECT * FROM student ORDER BY IF(name like 'b',0,name)

0

Importing .CSV

SQL statement comparing d...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Dear all, I have a problem with sql function: I want to change Amount column to Words, senirio is like this: i have a 2 column, 1 has name and 2 has amount in numbers and i want to convert that amoun...

Summary: Hello Everyone, I am having issues to connect to database from my sql navigator, here everyone else is able to connect to the same database without any problem. I have previously connected to the same...

Summary: I'm rusty with my SQL, but couldn't you do this?INSERT INTO A(primary_key, Name) SELECT sequence.NEXTVAL, name FROM SELECT DISTINCT name FROM B; ...