select only two rows in a table

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

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

---

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.

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

Jovery,

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

Regards.

Quote:

---

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

---

Quote:

---

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. :)

Quote:

---

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.

Quote:

---

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.

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

Quote:

---

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

---

Hanky, I ain't taking responsibility for you!