Thanks John for the help. I have managed to get an answer to my original question and I now know that SQL does not have a command similar to LIMIT...

Thanks guys for your help I will probably try the Row number I dont have SQL server installed on my machine but I will probably install it tomorrow. My...

I have done the questions and it was just question 4 I had problems with. I have just been told that SQL server does not have the LIMIT so question...

MySQL tables...

database.names

id, name

1, Tom

2, Simon

3, Sarah

4, Ann

5, Bernie

database.telephone_nums

id, name_id, telephone_number

1, 2, 01438 234 678

2, 5, 01438 765 890

3, 1, 01438 657 897

database.mobile_nums

id, name_id, mobile_number

1,...