SQL Tips

3 comments:

  1. Hi sir,
    Can you tell me the query to select only the rows in which all the column value will be unique and there should not be any row with duplicate column value.
    If so, then in result, the row with duplicate value and the row whose duplicate comes should not be in output.
    Only the rows with unique column value should come.

    Thanks.

    ReplyDelete
  2. Hi sir ,
    Can you please suggest which is the efficient way of querying for the building a query dynamically whether i can go with stored procedure or Dynamic Linq because am developing an asp .net mvc which requires multiple filtering . The user can apply 1 column filter or 2 or more i will know only at the compile time .Can you please suggest the right way with some explanation

    ReplyDelete