Re: SQL select question

Hi,

Try this

SQL> break on deptno skip 1
[Quoted] SQL> select *

          from emp
          order by deptno

dennishancy_at_eaton.com wrote in message <74m7gr$95l$1_at_nnrp1.dejanews.com>...
>I'm hoping this will be a simple SQL question to answer.
>
>I have a table with very few columns. I want to print each of the fields
in
>this table, which I know will be a simple "select * from TABLE" command.
>
>Ok, but I want to modify the output slightly. I think I need a "group by"
or
>"break on" clause, but I'm not sure. I'd like to have each group of
records
>having the same value for "field1" print together. In other words, having
a
>blank line in between each group is my goal.
>
>Can anyone shed some light on this for someone who doesn't use SQL that
much?
>Thanks.
>
>
>Dennis Hancy
>Eaton Corporation
>Cleveland, OH
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Dec 09 1998 - 21:39:18 CET