Re: SQL select question

Try this:
select * from table
order by field1

BEFORE executing this, enter
Break on field1 skip 1
at the SqlPlus command line

( in other words you can tell SqlPlus to break on any field that is in your order by or group by clause and you can specify how may lines to skip on the break)

dennishancy_at_eaton.com wrote:

>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

To reply please remove the 'nospam' part of the address Received on Wed Dec 09 1998 - 19:02:37 CET