Posts Tagged: partitioning

Home » partitioning

Hands-on SQL Tips: Sentinels And Window Functions

Sometimes when displaying data in an application you want the amount of data (rows, individual data points etc.) to be limited for the app to stay responsive and to allow the user to more easily scan and browse the data set. In SQL this is commonly done using a LIMIT statement: SELECT * FROM table LIMIT 100 Now, what if you want to not only display the data but also inform the user in case the total number of rows in the table ... Read more