select only two rows in a table

**Puja** · 03-03-2005, 06:20 AM

I like to select only two rows in a table where there is total five row. How I do that? Also I would like to save the result in text.

Thanks

**jovery** · 03-03-2005, 06:24 AM

What 2 rows do you want to select?

to save the result in text file use:

Code:

SQL> spool [filename]
SQL> ..run query..
SQL> spool off

**Puja** · 03-03-2005, 07:57 AM

Table name is acme. It has five columns. Column a, b, c d and e. I would like to select all from a and d and save the result to a file.

Many thanks.

**jovery** · 03-03-2005, 08:11 AM

Do you mean this.....

Code:

SQL> spool a_file.txt
SQL> SELECT a,d FROM acme;
SQL> spool off

If you don't then can you explain a bit more, if this is it you need to RTFM

**Puja** · 03-03-2005, 08:19 AM

Jovery,

That is what I was looking for. Thank you for your help.

Regards.

**DaPi** · 03-03-2005, 08:27 AM

Originally posted by Puja
I like to select only two rows in a table where there is total five row.

Originally posted by Puja
It has five columns. Column a, b, c d and e. I would like to select all from a and d and save the result to a file.

You really must learn the difference between a row and a column.

**JMac** · 03-03-2005, 12:14 PM

Originally posted by DaPi
You really must learn the difference between a row and a column.

You're getting soft chaps.

It wasn't even in the Developer's forum and you still helped out with only minor sarcasm.

**Mr.Hanky** · 03-03-2005, 12:19 PM

Originally posted by Puja
Jovery,

That is what I was looking for. Thank you for your help.

Regards.

He is a genius you know.
Taught me everything I know.

**Tarry** · 03-06-2005, 06:34 PM

Database business is is not booming anymore, me thinks...

**jovery** · 03-07-2005, 04:42 AM

Originally posted by Mr.Hanky
Taught me everything I know.

Hanky, I ain't taking responsibility for you!

Thread: select only two rows in a table