sql quesry statements

T

tucker

im having trouble understanding how to perform sql statements in
workign past papers.

can anyone help me with these questions


all female students who do not live within 10km of Bristol university
or less than 19 years old?


all students not called Jones or smith or less than 1.75m tall?


rewrite the following statement to perform the same query without the
or statement


age<21 OR sex= "male"


many thanks
 
S

smartin

tucker said:
im having trouble understanding how to perform sql statements in
workign past papers.

can anyone help me with these questions


all female students who do not live within 10km of Bristol university
or less than 19 years old?

[snipped]

I think you would be better off learning about logical statements. There
is nothing specific to SQL in the examples here.

However, you could try looking here:
http://www.w3schools.com/Sql/sql_and_or.asp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top