A B NOVA210601 AJI0001 NOVA210602 AJI0002 NOVA210591 AJI0003 NOVA210592 AJI0003 NOVA210593 AJI0003 NOVA210594 AJI0003 NOVA210595 AJI0004 NOVA210596 AJI0005 NOVA210597 AJI0006 NOVA210598 AJI0006 NOVA210599 AJI0006 NOVA210600 AJI0006 NOVA210570 AJI0006 NOVA210571 AJI0006 NOVA210572 AJI0006 NOVA210573 AJI0007 NOVA210574 AJI0008 NOVA210575 AJI0008 NOVA210576 AJI0008 NOVA210577 AJI0008 NOVA210578 AJI0008 NOVA210579 AJI0009 NOVA210580 AJI0009 NOVA210581 AJI0010 NOVA210582 AJI0011
NOVA210601 NOVA210602 NOVA210591 NOVA210595 NOVA210596 NOVA210597 NOVA210573 NOVA210574 NOVA210579 NOVA210581 NOVA210582
SELECT A FROM (SELECT A, B, RANK() over (Partition By B order by A ) as RANK FROM table) RS Where Rank =1
select min(ColumnA) from YourTable group by ColumnB
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)