Raj KAJ (scottobear) wrote,
Raj KAJ
scottobear

SQL Clause

 

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

 

or…

 

SELECT * FROM CONTACTS WHERE LOWER([BEHAVIOR]) = ‘nice’ ORDER BY [LASTNAME] ASC, [FIRSTNAME] ASC

Originally published at The Scotto Grotto. You can comment here or there.

Tags: uncategorized
Subscribe
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 0 comments