这个SQL语句要怎么写？急急！(38分)

P

progrand

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-08

• #1

比如一个表table1内有个aa字段，要找出这个表内aa字段内aa为''BB''的记录之间的记录，
比如第4条和第8条记录的aa为''BB'',则要找的就是第5到7条记录！
这样找好后，还要找到第5条到7条记录中cc字段为"dd"的记录
这个SQL语句要怎么写！

 

Y

ysai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-09

• #2

你想得到的结果是什么？
如果是按aa字段排序的话还可能，但有这个必要没有？

 

O

ourself

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-09

• #3

Do you have any index, or sort order requirements?

 

O

ourself

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-09

• #4

Presume you have an ID field, data type = integer, incremented by 1 for every
record, and the following is a trial SQL for your reference:

SELECT * FROM table1
WHERE
id>(
SELECT MIN(id)
FROM table1
GROUP BY aa
HAVING (aa = 'bb')
)
AND
id<(
SELECT MAX(id)
FROM table1
GROUP BY aa
HAVING (aa = 'bb')
)
AND
cc='dd'

 

A

allenk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-09

• #5

SELECT * FROM
(SELECT * FROM Table1 WHERE aa='BB') AS tmpQuery
WHERE tmpQuery.cc='DD'

 

A

allenk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-09

• #6

对不起，刚才没有理解你的意思

 

P

pursuer11

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-18

• #7

不太明白！

 

P

progrand

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-04-18

• #8

多人接受答案了。