fetch data from sql in very special format and display in some special format RRS feed

  • Question

  • User-400071421 posted


    I have search application and in my search application there are some premium clients and other free clients.

    Now whenever any user search at that time i wants to fetch 70% data free and 30% data of premium client and also i wants to search data in the manner of on each page 3 premium client and rest of free users and if click on next page then once again 3 premium client and rest free clients.if any idea then please let me know for it.

    Thursday, February 18, 2010 9:45 AM


  • User665034424 posted

    You can do this either in the backend (SQL) or in Business Layer.

    In either case, get the total number of records available as part of the search. Find the 70% or 30% of rows out of the total and display it accordingly.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, February 18, 2010 12:17 PM