December 17th, 2015

scotto monkeypulse

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.