locked
stored procedure How I need your help, by the way. RRS feed

  • Question


  • Hello how can I hope they can help me I have these two select I need to include them in a stored procedure someone could give me an idea how to put it? To make an EXeCute (2), (4)
     The 2 is the size of the window and the 4 is the public id

    SELECT * FROM PUBLICATIONS ORDER BY public_id DESC OFFSET 0 ROWS FETCH NEXT 3 ROWS ONLY


    SELECT * FROM Publications WHERE public_id <2 ORDER BY id_public OFFSET 0 ROWS FETCH NEXT 3 ROW ONLY
    • Edited by HNymeria Monday, August 7, 2017 5:48 PM
    Monday, August 7, 2017 4:54 PM

Answers