Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Can you not just copy and paste into excel?!Morning all
I need to start teaching myself how to query a SQL database for my role at work. I don't need to be advanced straight away but to be able to query a few tables and lookup tables between 2 dates etc. Can anyone recommend a decent book to get me started please?
Cheers
Sometimes when you’re blagging your job it’s not wise to let your employer know your cv is a magnificent work of fiction…Does your employer not offer an opportunity to do some training on SQL?
Truth is the best policy, at some point you will get found out and that does not feel good.Sometimes when you’re blagging your job it’s not wise to let your employer know your cv is a magnificent work of fiction…
Tie the data to a chair and stick electrodes in its knees like Brian did.Cheers everyone. I'm not trying to blag my job I just want to be able to interrogate some data.
Also JOIN. I’ve seen so many people who query one table, stuff the results in an array, then make another SQL query for every item in the array. A join does it in a single line. Or using things like LEFT JOIN can find all items in one table but not the other.The basics aren't really very difficult at all.
Learn the various forms of SELECT, how to GROUP and ORDER things and if you have a large database, ensure you know about the different types of JOIN and with that you should be able to do most queries.
As stated above, there is plenty of advice online, so you really shouldn't need a physical book these days.
I don't know what platform or type of SQL you are using, but many query packages will let you assemble your query with a point and click type approach, and actually build up the SQL syntax so you can see how they get the result.
Also JOIN. I’ve seen so many people who query one table, stuff the results in an array, then make another SQL query for every item in the array. A join does it in a single line. Or using things like LEFT JOIN can find all items in one table but not the other.