Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2013
    Posts
    2

    Question Unanswered: Some questions about writing SQL statement. Can anyone help me?

    Hello, since the exam is coming, I am having revision and doing the pastpaper about writing SQL statement. However, I find some difficulties. Can anyone solve my problem? Thank you!!!

    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so what have you tried
    what are you stuck on
    where do you think your are weak/exposed
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2013
    Posts
    2
    Quote Originally Posted by healdem View Post
    so what have you tried
    what are you stuck on
    where do you think your are weak/exposed
    I can read the question
    but I dont know what I need to do
    for example
    which type of question I need to write a SQL statement,
    and whether the statement that I type is correct.

    Actually, I am just a beginner of DB. Hope anyone can help me
    Anyway, thank you for your reply.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so if you've not studied anything, and you don't know what to do, what makes you think you are ready to take an exam?
    which type of question I need to write a SQL statement,
    and whether the statement that I type is correct.
    well the traditional way is to create some tables, put some data in the tables then develop your queries so that they provide the answers the question demands

    of course you could just take a wild guess and not bother proving your assumptions but then as you point out how would you know if the SQL is correct?
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,422
    Provided Answers: 7
    Quote Originally Posted by healdem View Post
    so if you've not studied anything, and you don't know what to do, what makes you think you are ready to take an exam?

    well the traditional way is to create some tables, put some data in the tables then develop your queries so that they provide the answers the question demands

    of course you could just take a wild guess and not bother proving your assumptions but then as you point out how would you know if the SQL is correct?
    straight to the point like it

    and people like that think they will get a DB job once they pass the test
    I have work on a number of database that have been build wrong and it been a rewrite and trying to tell the BOSS the last person .... up and I have to fix it
    Last edited by myle; 10-14-13 at 20:11.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •