WITH sql_users AS ( SELECT u.id FROM users AS u JOIN post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

WITH sql_users AS (
  SELECT u.id
  FROM users AS u
  JOIN posts AS p ON p.owneruserid = u.id
  WHERE p.posttypeid = 1
  AND u.reputation > 100
  AND p.tags LIKE '%sql%'
),
  java_users AS (
  SELECT u.id
  FROM users AS u
  JOIN posts AS p ON p.owneruserid = u.id
  WHERE p.posttypeid = 1
  AND u.reputation > 100
  AND p.tags LIKE '%java%'
)
SELECT DISTINCT TOP 10  s.id
FROM sql_users AS s
JOIN java_users AS j
ON s.id = j.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results