<div>
Do you have fixed no. of years? <br />
Do you want the result pivoted as mentioned above?
</div>


Do you have fixed no. of years?
Do you want the result pivoted as mentioned above?

<div>
i dont know which years they are... i hoped that the years could be taken from the data.
</div>


i dont know which years they are... i hoped that the years could be taken from the data.

<div>
Can you provide some sample data with expected result?
</div>


Can you provide some sample data with expected result?

<div>
Not exactly the solution i wanted... but it worked..
</div>


Not exactly the solution i wanted... but it worked..

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
<br />
I have a table that has patient-id, visit year, plus some other columns....<br />
<br />
It is possible to write some sql that produces a simple frequency table that shows me year and number of visits for each patient?<br />
<br />
I am particularly interested in seeing which years the patient did not make any visit, but also need to see how many visits per year in the other years. &nbsp;i.e. i dont want to exclude the years the patients did not visit.<br />
<br />
Also if it is possible I would like to go a step further an see the distribution of the number of visits. &nbsp;What i mean by this is I would like to see for each year how many patients made zero visits, how many one, how many two, how many three etc.<br />
<br />
Thanks.<br />

</div>
</div>


Hello,


I have a table that has patient-id, visit year, plus some other columns....

It is possible to write some sql that produces a simple frequency table that shows me year and number of visits for each patient?

I am particularly interested in seeing which years the patient did not make any visit, but also need to see how many visits per year in the other years.  i.e. i dont want to exclude the years the patients did not visit.

Also if it is possible I would like to go a step further an see the distribution of the number of visits.  What i mean by this is I would like to see for each year how many patients made zero visits, how many one, how many two, how many three etc.

Thanks.


tsql syntax

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.