Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rhysE_b
Starting Member
4 Posts |
 Posted - 2009-11-06 : 11:09:31
|
| Hey Guys,If i was looking to sort everyone by the age of 25 or over would th command be this?WHERE Age >= '25'ThanksRhys |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rhysE_b
Starting Member
4 Posts |
Posted - 2009-11-06 : 11:18:04
|
| i have a test question that i have no idea what the answer is the question is."Please write an SQL query to display the first name, surname, and sex of all the technicians who are 25 and over"and then under the question i have a table that looks something like this -First Name | Surname | Age | Sex | PositionWith 28 names and so on..So far i have got....select[First Name], Surname, Sex from Employeeswhere age >= '25'and Position = 'technician' |
 |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-11-06 : 11:42:30
|
| are you getting correct results when you run the query? if age is numeric you dont need quotes around 25 |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-11-06 : 11:43:28
|
| That looks about right. The age field is probably a number field, so usewhere age >= 25, without the quotes.JimEveryday I learn something that somebody else already knew |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Is this command correct