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
sql-server-2005
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