1 Reply Latest reply on Aug 27, 2013 10:18 PM by Dimitri.B

    Filter top N from custom SQL

    Jess Lee

      I know there is a feature in Tableau that i can filter top N.  But i would like to filter top N data from a custom SQL.  Is there any way?

       

      For example from below table,  I would like to write a query to extract only top 3 (id = 5, 1 and 16)

       

      id#
      119
      23
      36
      415
      520
      611
      72
      83
      91
      1016

       

      Thank you,

      Jessica