Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL Search Query String

Avatar of Erika Koelle
Erika KoelleFlag for United States of America asked on
DatabasesSQL
5 Comments1 Solution89 ViewsLast Modified:
I have a project that just had the parameters changed.  It used to be that an employee logs in and see's the work that's assigned to them only.  Now the employee is supposed to sign in and see their job assignments first and then other job assignments.  In the old days the command was select * from table where employee = 'john'

Results:
Name:   Job Stop:
John      123 Main St
John      876 Oak Ave
John      345 Maple Road

This was fine because the person in charge of operations just wanted names and the order of the database which was imported from an Excel spreadsheet to remain the same.  Now from a logic perspective, I'm not quite sure how to do a:
select * from table where [employee] = 'john' -- list these first in no order other than how originally in database and then list all the others
I guess I could be sloppy and have a 2nd select there such as:
select * from table where not [employee] = 'john'

Results:
Name:   Job Stop:
John      123 Main St
John      876 Oak Ave
John      345 Maple Road
Tom      643 Birch St
Tom      222 Rose Ave
Bob      909 Sky Drive
Josh      877 Park Ave

Thanks in advance...
ASKER CERTIFIED SOLUTION
Avatar of NerdsOfTech
NerdsOfTechFlag of United States of America imageTechnology Scientist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers