Is it “SELECT * WHERE a=b FROM c” or “SELECT WHERE a=b FROM c ON *” ?
If you’re anything like me, SQL is one of those things that may look easy at first (it reads just like regular english!), but for some reason you can’t help but google the correct syntax for every silly query.Then, you get to joins, aggregation, and subqueries and everything you read just seems like gibberish. Something like this :
SELECT members.firstname || ‘ ‘ || members.lastname
AS “Full Name”
INNER JOIN members
INNER JOIN books
WHERE borrowings.bookid IN (SELECT bookid
WHERE stock>(SELECT avg(stock)
GROUP BY members.firstname, members.lastname;
Yikes! This would scare any new comer, or even an intermediate developer looking at SQL for the first time. It shouldn’t have to be like this.
It’s always easy to remember something which is intuitive, and through this guide, I hope to ease the barrier of entry for
Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/yDsbpaqYmHc/