Remove duplicate entry in sql query

Question

Hi,
 
I want to truncate duplicate rows but Qty should be added
 
I have a table filled with data,
 

Item Qty MinQty MaxQty
ABC10 20 50
XYZ 12 30 40
ABC 15 20 50
 
I want the result like,
Item Qty MinQty MaxQty
ABC25 20 50
XYZ 12 30 40
 
Kindly help me to write the query for the same...

Answer 1

If you are looking for a code to get the selected values from checkboxlist then you can use below code

var checkboxValues = [];
                //Get selected value from checkbox like below
                $('[id*=chktagindex] input:checked').each(function () {
                    checkboxValues.push(this.value);
                });
                var result = checkboxValues.toString();

 You need to change the checkboxlist markup like below

<asp:CheckBoxList ID="chktagindex" runat="server" Width="162px">
                <asp:ListItem Text="TagIndex1" Value="TagIndex1"> </asp:ListItem>
                <asp:ListItem Text="TagIndex2" Value="TagIndex2"></asp:ListItem>
                <asp:ListItem Text="TagIndex3" Value="TagIndex3"></asp:ListItem>
            </asp:CheckBoxList>

 

Answer 2

Hi Nitish,

As you have given heading of your question "checkboxlist select query in j query" and also provided your code snippet. But, you have not properly ask what difficulty you are facing? So, can you modify your question for better understanding?

Thanks