Writing an SQL query - please HELP!!

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Writing an SQL query - please HELP!!

Author

Topic

rhysE_b
Starting Member

4 Posts

Posted - 2009-11-06 : 10:34:54

Im new to this forum so sorry if i am posting in the wrong place.
I am wondering if anyone can help me, 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 | Position

With 28 names and so on..

If anyone could help with the answer/commands for this that would be great.

Thanks
Rhys

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-11-06 : 11:08:16

select
[First Name], Surname, Sex
from your_table
where age >= 25
and Position = 'technician'

But I am not sure if exists Position = 'technician' in your table.

No, you're never too old to Yak'n'Roll if you're too young to die.