Intrebari generale

Re: nested select, e posibil?

noface — Thu, 16 Jul 2009 12:46:31 GMT

Multumesc Catalin, a mers impecabil

Re: nested select, e posibil?

katalyn — Thu, 16 Jul 2009 11:51:19 GMT

Nu stiu daca inteleg prea bine dar poate vrei ceva de genul:

SELECT nrcontract,appid,rezolutie, comentarii,
(
SELECT max(c)
FROM (
SELECT dataplata AS c, nrcontract
FROM history
UNION ALL
SELECT lastphonedate AS c, nrcontract
FROM history
) u
WHERE h.nrcontract = u.nrcontract
)as t2,
max(contactno)+1 as MaxC, lastmodifiedby, lastmodifydate
FROM history h
WHERE nrcontract='1'
GROUP BY nrcontract, appid, rezolutie, comentarii, lastmodifiedby, lastmodifydate

Te rog sa postezi scriptul de creare pentru tabela si sa explici ce anume doresti sa intoarca selectul. Asa doar am presupus cate ceva .........

nested select, e posibil?

noface — Thu, 16 Jul 2009 11:17:57 GMT

salut.
as vrea sa imi spuneti dc exista posibilitatea ca, intr-un sg query, sa fac ceva de genul urmator( ce este intre [[[ si ]]] reprezinta dilema mea,nu stiu forma sub care as putea nest-ui acel select ca parte din selectul principal):

select
nrcontract,appid,rezolutie,
comentarii,
[[[ SELECT max(c) FROM
(SELECT dataplata AS c FROM history
UNION
SELECT lastphonedate AS c FROM history) as t2 ]]]

,max(contactno)+1 as MaxC,lastmodifiedby,lastmodifydate from history
where nrcontract='1' group by ....