Editorial Summary :

When presenting tabular data (i.e. data in a table), you may want to have a “total” row at the bottom . It’s more efficient to create a ‘total’ row in . SQL (server side) and make it easier for the front-end developer . The first approach I’ll mention is to basically create a copy of your dataset . We can fix this by updating our . ORDER BY clause to include a CASE statement: Where ever the column says “Total” give it a value of 1 .

Key Highlights :

  • When presenting tabular data, you may want to have a “total” row at the bottom .

The editorial is based on the content sourced from medium.com

Read the full article.

Similar Posts