Lets face it. We programmers are lazy. We like to do things the quickest way possible using the least possible effort. The other thing most programmers do a lot is work with databases and SQL. Weather designing the backend functionality on a website, or creating an app that needs to manipulate data form a database, we always end up writing queries to interact with our databases. So the purpose in this tutorial is to make you aware of some functions that are built in to SQL which could make our lives that wee bit easier.
Read the rest of this entry »