Sql query number of occurance

Posted by phenevo on Stack Overflow See other posts from Stack Overflow or by phenevo
Published on 2010-04-29T11:13:47Z Indexed on 2010/04/29 11:17 UTC
Read the original article Hit count: 138

Filed under:

Hi,

I wanna to have query:

Select cars.* from cars where cars.code in
(
select carCode from articles where 
numberofrecords with this car (it is not a column) >1
and Accepted=1
order by date
)

How to write it?

© Stack Overflow or respective owner

Related posts about sql-server-2005