SQL hidden techniques?

Posted by AlexRednic on Stack Overflow See other posts from Stack Overflow or by AlexRednic
Published on 2010-05-28T16:08:28Z Indexed on 2010/05/28 16:11 UTC
Read the original article Hit count: 282

Filed under:
|
|
|
|

What are those pro/subtle techniques that SQL provides and not many know about which also cut code and improve performance?

eg: I have just learned how to use CASE statements inside aggregate functions and it totally changed my approach on things.

Are there others?

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql