|
As a never ending twist and turns in my career, I have been asked to work on Sql queries ( only Select to populate data and copy in excel).
I worked on it like 15 years back and never touched sql script.
So any links or online resource to brush up my memory?
cheers,
Super
------------------------------------------
Too much of good is bad,mix some evil in it
|
|
|
|
|
Repeat after me:
SELECT * FROM
someting AS st INNER JOIN
somethingelse AS se ON se.SomethingId = st.Id
Shirley this already brought it all back, right? 
I have lived with several Zen masters - all of them were cats.
|
|
|
|
|
Arrrgh! NOOOOO!
SELECT st.TingOne, st.TingTwo, se.TingThree FROM
someting AS st INNER JOIN
somethingelse AS se ON se.SomethingId = st.Id
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Try typing "SQL SELECT" into Google.
|
|
|
|
|
select * from google
... About 1,040,000,000 results (0.50 seconds)
pfffft, is that all they have? disappointing!
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
W3Schools cover it all, but can be a bit "brick wall" from time to time.
This is OK: SQL Tutorial - Learn SQL Query Programming Language[^]
And there are some very handy bits added in the last 15 years such as LEAD and LAG which give you access to the next and previous row in a dataset.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: And there are some very handy bits added in the last 15 years such as LEAD and LAG
be careful though, some people haven't upgraded for even longer,
others, dare I say it, use access
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
Some of us happen to like the SQL92 standard, as it is available for most databases. Makes your queries a bit more portable 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: ome of us happen to like the SQL92 standard, as it is available for most databases. Makes your queries a bit more portable 
yup, I'm one of those too, standard, portable, readable.
...in fact didn't know what LEAD and LAG was till OG mentioned it in this thread - had to google it, and 90% of my work involves SQL databases
- a lot lately on FireBird 1.5 which is old, has almost no extensions, but it is SQL92, and that's all that matters.
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
Lopatir wrote: yup, I'm one of those too, standard, portable, readable.
Not as sexy as the cloud, but plain and boring - which is a good thing sometimes
Lopatir wrote: it is SQL92, and that's all that matters
Not all, but most; if you're programming directly against a specific database-provider you'd still have a lot of database-specific code. If you program against the interfaces and you use SQL92, then changing the type of database should not be much of a problem.
In that case, any database that has a database-provider in .NET and is SQL92-compliant will work. It's the difference between telling the customer that you use "database X, version Y" and telling the customer "any SQL92 DB you like or have".
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I don't worry too much about portable - I just make sure I develop using the same version of SQL as the target production system: so currently SQL 2012 SP1.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
It is hardly a worry; but as good as MSSQL 2012 is, it still is a vendor lock in. Not a vendor that is likely to go bankrupt, but stranger things have happened. For using a bit less fewer new features, you get flexibility in return.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
This is true, but ... even if MS went bust tomorrow, SQL server will keep on working - and there would be much more pressing matters than replacing it in a hurry! 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
it's not so much ms going bust as compared to if they keep doing what they do... they do have a history of changing the way things work,
for instance ie, once upon a time css had to test for ff vs ie, but then ms upped the ante by changing their own difference, so then there were tests not only for ie, but which version of ie.
What this means if you use their non standard features: you've put a bunch of code out to clients, along comes a new version of whatever you're using from ms, some clients upgrade, some don't - your code breaks in some places but not others.
in fact it'd almost be a good thing if ms went bust, at least they would no longer be changing stuff depending on which way nads farts are blowing, including still breaking their own staff regardless it works or not.
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
SQL Tutorial[^]
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
|
A nice and informative article about SQL.
Print out the last picture for framing 
Press F1 for help or google it.
Greetings from Germany
|
|
|
|
|
Check out some of Sander's articles. Very good for brushing up. Sorry, I don't have links, but assume you know who I'm referring to.
"Go forth into the source" - Neal Morse
|
|
|
|
|
In general SQL Server Central [^] no matter what your expertise / level.
They have a log of good 'stairways' you can start with the Stairway to T-SQL DML – a SQL Server tutorial[^]
DML == Data Manipulation Language (the aspect of the language dealing with the data: SELECT, INSERT, UPDATE and DELETE)
I'd recommend you review all of DML, not just select... but that's my opinion.
HTH,
-Chris C.
|
|
|
|
|
I have downloaded the JDK setup file for version 8
I am trying to also download it for version 9
Can't figure it out.
Version 8 was clear, obvious, and simple; i.e., for Windows 64 bit, click and it happens.
Version 9 presents screens that I can't comprehend.
Like, where is it ?
These are the two URLs which I was instructed to use...
Thank you to anyone who knows the secret process; and especially thanks to anyone who knows it and will provide a response that makes sense and actually leads me to the knowledge of how to actually find the thing in the first place.
Machine here is Windows 7
|
|
|
|
|
|
It looks like Java 9 only supports Linux ...
For now?
|
|
|
|
|
Java 9 has been released. All of the targets are supported for that.
|
|
|
|
|
Java SE Development Kit 9 - Downloads[^]
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
|
You should post this in the Java forum.
The regulars here should abide buy the same rules they impose on newcomers, without exception.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
