2014/1/11 Atul Chowdhury <[email protected]> > You're probably after something like the BREAK directive found in SQL*Plus. > > See: http://docs.oracle.com/cd/A84870_01/doc/sqlplus.816/a75664/ch42.htm > > SQL> BREAK ON DEPTNO > SQL> SELECT DEPTNO, ENAME, SAL > 2 FROM EMP > 3 WHERE SAL < 2500 > 4 ORDER BY DEPTNO; > SQL*Plus displays the following output: > DEPTNO ENAME SAL > ---------- ----------- --------- > 10 CLARK 2450 > MILLER 1300 > 20 SMITH 800 > ADAMS 1100 > 30 ALLEN 1600 > JAMES 950 > TURNER 1500 > WARD 1250 > MARTIN 1250 >
Yes, that is exactly what I want. This is not possible in H2? -- Cecil Westerhof -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
