• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Reply to: A little fun ..

Collapse

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

  • You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
  • You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
  • If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Previously on "A little fun .."

Collapse

  • original PM
    replied
    Originally posted by NotAllThere View Post
    No.

    SELECT * is a select clause
    WHERE behavior = 'nice' is a where clause.

    Don't give up your day job.
    Yeah it's been a while - let the minions deal with it nowadays.

    Leave a comment:


  • NotAllThere
    replied
    Originally posted by original PM View Post
    I think the inclusion of a where makes it a clause of some sort.
    No.

    SELECT * is a select clause
    WHERE behavior = 'nice' is a where clause.

    Don't give up your day job.

    Leave a comment:


  • DaveB
    replied
    Originally posted by Whorty View Post
    ** stolen from the interweb **

    For those PMs who struggle with SQL, ask someone to explain it to you

    He's making a database
    He's sorting it twice
    SELECT * from contacts WHERE behavior = 'nice'
    SQL Clause is is in breech of Article 8 and Article 22 of the General Data Protection Regulation as enacted in the Data Protection Act 2018
    FTFY

    Leave a comment:


  • original PM
    replied
    I think the inclusion of a where makes it a clause of some sort.

    Leave a comment:


  • Cirrus
    replied
    Surely that's not an SQL clause; it's a statement. :

    Leave a comment:


  • Old Greg
    replied
    Originally posted by Whorty View Post
    ** stolen from the interweb **

    For those PMs who struggle with SQL, ask someone to explain it to you

    He's making a database
    He's sorting it twice
    SELECT * from contacts WHERE behavior = 'nice'
    SQL Clause is coming to town
    So that's two person days' effort. Jolly good. Now, chop chop.

    Leave a comment:


  • greenlake
    replied

    Leave a comment:


  • woohoo
    replied
    Dodgy sql, no criteria on age or group on location. Santa has outsourced his dba.

    Leave a comment:


  • TwoWolves
    replied
    They don't believe in SQL clause at my place - gone NoSQL.

    Leave a comment:


  • xoggoth
    replied
    Oi!!!! Give that ere! It's MySQL!

    Leave a comment:


  • Whorty
    started a topic A little fun ..

    A little fun ..

    ** stolen from the interweb **

    For those PMs who struggle with SQL, ask someone to explain it to you

    He's making a database
    He's sorting it twice
    SELECT * from contacts WHERE behavior = 'nice'
    SQL Clause is coming to town

Working...
X