>>As regards industry, I looking for sql queries in hospitality eg NHS
I didn't ask for industry. I asked for the database product you wanted this SQL for. Each database product has its own unique tweaks to the ANSI standard.
Judging by former questions from Member_2_7966113 the database might be Microsoft SQL Server. Occasionally SQL Server users refer to that database by the abbreviation "SQL" and assume we know what that means.
SQL became a standard of the American National Standards Institute (ANSI) in 1986, ...
Despite the existence of such standards, most SQL code is not completely portable among different database systems ...
The reason why we ask to know "which database?" is because the syntax needed in (say) MS SQL Server is very different to PostgreSQL or Oracle etc. nb: The tag "SQL" does NOT indicate MS SQL Server.
---------------
@slightwv
If I see "NHS" I think of "National Health System" in the UK. It could mean "National Highway System", but I believe it is more likely to be the former.
Geert G
the querries are questions for the database
the answers are what the database returns as data
the answers will differ depending on what data is in the database ...
I looking for something similar pertains to the Healthcare industry. As I couldnt find a book I was hoping that someone from EE could point me to link with a library of various SQL Queries and Answer to various industries including the Healthcare industry.
Does that make sense?
PortletPaul
Good luck locating such a specific book.
(I'm currently thinking of little britain... Margroot, do we have a purple pirate game for 14 year olds?)
Most texts will stick to "generic" topics in the expectation you can extrapolate to your own situation.
slightwv (䄆 Netminder)
Personally, I wouldn't spend money on that book. They rely way too much on inline views that hit the same base tables used in the outer query.
Many of those can be rewritten to take advantage of WINDOW functions and only access the tables once.
That said:
I understand the desire to learn SQL in a filed where you will be applying it but data is data is data. SQL to access the data is SQL.
Learning how to compute average repair costs on a Ferrari should be pretty much the same as computing the average cost of a heart transplant. Except the Ferrari is cheaper... ;)
Oracle also has a pretty liberal development and education license if the Express Edition doesn't have a component you wish to experiment with. For basic SQL, it should be fine.
Member_2_7966113
ASKER
Hi Slightwv, I don’t I made myself clear.
I meant sample databases like a sample sales, marketing etc database of tables that I can download and attach to my SQL server and run queries on.
There is a LOT of answered questions here if you look through the Topic Areas.
If you are looking for some sort of exam prep for SQL, there are a few if you Google around.
SQL also varies from database to database. What database are you interested in?