#226 SQL DATA TAB

General
open
Rob Manning
General (118)
5
2012-12-29
2007-01-03
Ginko
No

LIKE DBVIS
WOULD BE USEFUL, IN SQL RESULTS TABLE, TO BE ABLE TO

1)SELECT ONE ROW OR ONE COLUMN

2)CALCULATE THE SELECTION (MIN; MAX; AVG; SUM; NUMBER OF CELLS)

3)SIMPLE FILTER: TO QUICKLY LIST ONLY THOSE ROWS THAT MATCH THE ENTERED SEARCH STRING.

4)WHERE FILTER: USED TO FORM THE WHERE CLAUSE THAT WILL LIMIT THE NUMBER OF ROWS IN THE GRID.

Discussion

  • Logged In: NO

    Great idea

     
  • These options might be nice to have, but I personally would give this a very low priority, as this all can be achieved via proper SQL commands, or you export the result into a spreadsheet file and use a spreadsheet program that can handle your output.

    (But it already is assigned anyway, so my comment might be too late :-)