'Writing an SQL Query' Thread RSS Feed

Writing an SQL Query

Fri, 06 Nov 2009 07:01:58 -0700

Hi Guys,

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

Re: Writing an SQL Query

Fri, 06 Nov 2009 11:53:29 -0700

Sorry, I don't see you this question, I'm sorry. I wish you to find the correct answer
www.see-shoes.com

Re: Writing an SQL Query

Fri, 06 Nov 2009 11:55:15 -0700

Sorry, I don't see you this question, I'm sorry. I wish you to find the correct answer
www.see-shoes.com

Re: Writing an SQL Query

Mon, 09 Nov 2009 12:16:12 -0700

I wish you to find the correct answer。I’m sorry.

Re: Writing an SQL Query

Mon, 09 Nov 2009 14:38:53 -0700

SELECT First Name, Surname, Sex, FROM NameOfTable WHERE Age > 25 AND Position = 'Technician'

Obviously change NameOfTable to the actual table name, if you wanna be fancy you could add at the end:

ORDER BY Age Asc

or

ORDER BY Age Desc

To sort it by age, ascending or descending, or you could sort it by Surname or whatever. Dai

------------------------------------------
Do or do not, there is no try. |
------------------------------------------