<div>
How do we know which one is the top?<br />
By the examples you gave I would say is alphabetic ascending order?
</div>


How do we know which one is the top?
By the examples you gave I would say is alphabetic ascending order?

<div>
Vitor,<br />
I just need it to pick one. &nbsp;How can I do this? &nbsp;It doesn't really matter which one it picks, as long as it only picks one.<br />
<br />
mrotor
</div>


Vitor,
I just need it to pick one.  How can I do this?  It doesn't really matter which one it picks, as long as it only picks one.

mrotor

<div>
And something like :<br />

<pre><code id="code-20-40774599-1">select 'ORDER1', min(SKU) from ORDER1
union
select 'ORDER2', min(SKU) from ORDER2
union
select 'ORDER3', min(SKU) from ORDER3</code></pre>
</div>


And something like :


select 'ORDER1', min(SKU) from ORDER1
union
select 'ORDER2', min(SKU) from ORDER2
union
select 'ORDER3', min(SKU) from ORDER3

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
I have to write a query that returns the top SKU on each of my orders.<br />
<br />
I have 3 order<br />
<br />
ORDER1 has the following SKUs<br />
ABC123<br />
DEF456<br />
<br />
ORDER2 has the following SKUs<br />
DEF456<br />
XYZ765<br />
ZZZ656<br />
<br />
ORDER3 has the following SKUs<br />
EFG123<br />
RRS697<br />
XYZ765<br />
XYZ999<br />
<br />
<br />
I want my query to return the following result<br />
<br />
ORDER # &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TOP SKU<br />
<br />
ORDER1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC123 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
ORDER2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DEF456<br />
ORDER3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EFG123 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
<br />
<br />
How can I do this? &nbsp;Thanks in advance,<br />
mrotor
</div>
</div>


Dear Experts,
I have to write a query that returns the top SKU on each of my orders.

I have 3 order

ORDER1 has the following SKUs
ABC123
DEF456

ORDER2 has the following SKUs
DEF456
XYZ765
ZZZ656

ORDER3 has the following SKUs
EFG123
RRS697
XYZ765
XYZ999


I want my query to return the following result

ORDER #		TOP SKU

ORDER1		ABC123	
ORDER2		DEF456
ORDER3		EFG123	



How can I do this?  Thanks in advance,
mrotor

I have a question regarding a query in SQL Server 2008 R2

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.