SQL Query Questions Answers

Question

Post reply

SQL Query Questions Answers

carlton 84646

Ten Centuries

Points: 1026
More actions
October 15, 2018 at 1:49 pm

#408966

Hello Community,
Can someone please let me know where I can find a repository of sql queries and answers?
For example, I would like for find a repository of SQL queries and answers for the healthcare industry.
Thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 1

It's not possible for us to tell if you'll be the interviewer or the interviewee. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 2

Hi Jeff,

I don't know what you mean by interviewer or interviewee .. I'm a newbie

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 3

A lot of people as for questions to help them prep for interviews for jobs that they're not actually qualified to do. It's given me a bit of a jaundice eye when people ask such questions as you did... especially when they also want the answers to the questions.

I've not made such a search for questions of the nature you ask but a look at "Yabingooglehoo" for the following should be a help.

If you look at "SQL questions and answers medical databases" on Google and look at the "pull down" for other subjects, you should get a snoot full of what to look for. You might also want to do a search for "SQL HIPPA COMPLIANCE".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 4

One point, since there are a large quantity of completely different databases that store healthcare information, you are unlikely to find a generic list of "SQL queries" that will apply to the specific database you're using. It's very likely that you'll need to learn that database and write (or track down, it is possible) queries for that database, not simply "healthcare databases". There are far too many of them and they are absolutely not standardized (despite HIPAA).

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning