<div>
<div class="content wysiwyg-content">
Here is some sample data from the case_text table<br />
<br />
company_id &nbsp; &nbsp;case_id &nbsp; &nbsp;text_type_code &nbsp; &nbsp;case_text_seq<br />
MIS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Resolution &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21<br />
MIS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Resolution &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22<br />
MIS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Resolution &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5<br />
MIS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Resolution &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6<br />
MIS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Resolution &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4<br />
<br />
I am trying to create a query that will return the row with the highest case_text_seq value for a given combination of company_id, &nbsp;case_id, &nbsp;and &nbsp;text_type_code &nbsp; &nbsp;<br />
<br />
Using the sample data above, I would like the query results to look like the following:<br />
<br />
company_id &nbsp; &nbsp;case_id &nbsp; &nbsp;text_type_code &nbsp; &nbsp;case_text_seq<br />
MIS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Resolution &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22<br />
MIS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Resolution &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6<br />

</div>
</div>


Here is some sample data from the case_text table

company_id    case_id    text_type_code    case_text_seq
MIS                  1              Resolution             21
MIS                  1              Resolution             22
MIS                  2              Resolution             5
MIS                  2              Resolution             6
MIS                  2              Resolution             4

I am trying to create a query that will return the row with the highest case_text_seq value for a given combination of company_id,  case_id,  and  text_type_code    

Using the sample data above, I would like the query results to look like the following:

company_id    case_id    text_type_code    case_text_seq
MIS                  1              Resolution             22
MIS                  2              Resolution             6


How to select max row per group in SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.