quote:

---

Originally posted by easy_goer


Hello. I have a portion of a table that looks like what I've listed below. This is just a small subset of the data that I'm attempting to retrieve, but this displays what the structure looks like. What I would like to do is have a script that can pull all but the top two lines. So, I want to get everything that's below the line that contains "E-Mail". Hope this makes sense.

Right now, I can pull lines 3 and 4 by using the script below, but I would like also to capture the last line in my results. Any ideas?

select Column1, Column2, Column3, Column4
from Table
where Column2 in
(select Column1 from Table
where Column1 = '22701')


Column1 Column2 Column3 Column4
8106 NULL Top 8106
22701 8111 Test2 8106
26892 22701 Extra1 8106
26893 22701 Extra2 8106
26894 26892 ExtraSub1 8106

Thank you!

---

select Column1, Column2, Column3, Column4
from Table
where Column1 > 26000;

select TOP (3) Column1, Column2, Column3, Column4
from Table
order by Column1 desc 

select Column1, Column2, Column3, Column4
from Table
order by Column2 desc

select Column1, Column2, Column3, Column4
from Table
where Column3 not in ('Top','Test2');

select Column1, Column2, Column3, Column4
from Table t
where Column1 <> Column4
and not exists (select 1
from Table where Column2 = t.Column1 and Column4 = t.Column4)

quote:

---

Originally posted by easy_goer

Hello. I apologize that my original post was a bit unclear. Based on the table in my original post, I am able to pull the following

26892 22701 Extra1 8106
26893 22701 Extra2 8106

with this script..

select Column1, Column2, Column3, Column4
from Table
where Column2 in
(select Column1 from Table
where Column1 = '22701')


However, I would like to come up with a script that will display the following results..

26892 22701 Extra1 8106
26893 22701 Extra2 8106
26894 26892 ExtraSub1 8106


Does this make more sense?

---