Help with Select Statement

Question

Post reply

Help with Select Statement

Matthew24

SSCommitted

Points: 1736
More actions
March 26, 2009 at 3:40 pm

#202289

Hi Guys,

I am self-teaching SQL statements. Wondering if the following is achievable.

Table with 4 columns, lets call them 1,2,3 and 4

Column 1 contains numeric data, and one row in column 4 contains the character 'X'

What I want is a statement that will return all rows where the value of column 1 is equla or less than the row where column 4 has the 'X'.

Hope that this makes sense. Any help much appreciated.

Matt

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jetro Ten Centuries Points: 1257 More actions · Answer 1

Hi,

I'm not sure if I understood your question correctly 🙂 but i'll give it a try.



create table tester

(

  num int,

  my char(1)

)

insert into tester values (1,'')

insert into tester values (2,'')

insert into tester values (3,'X')

insert into tester values (4,'')

-- the query

select * from tester

where num <= (select num from tester where my = 'X')