Kombinera TOP 10 med distinct

distinct kvalificerar alla kolumner.

Vilket vill du ha applicerat först, top eller distinct?

...eee vad är skillnaden?
Detta vill jag göra: Hämta tio poster utan dubletter.

Dubletter med avseende på vad?

Alla kolumner:

select top 10 *
from (select distinct * from t) dt

OK, här är hela frågan:

SELECT DISTINCT(s.id), s.pname, s.city, s.province, CASE WHEN sp.shid IS NULL THEN 0 ELSE 1 END, updateddate
	FROM search1 AS s 
	LEFT JOIN search_pics AS sp 
	ON s.id=sp.shid
	ORDER BY updateddate DESC

Jaha

select top 10 * from (
SELECT DISTINCT s.id, s.pname, s.city, s.province, CASE WHEN sp.shid IS NULL THEN 0 ELSE 1 END, updateddate
	FROM search1 AS s 
	LEFT JOIN search_pics AS sp 
	ON s.id=sp.shid ) dt
ORDER BY updateddate DESC

Jag testade det men får : No column was specified for column 5 of 'dt'.

select top 10 * from (
SELECT DISTINCT s.id, s.pname, s.city, s.province, CASE WHEN sp.shid IS NULL THEN 0 ELSE 1 END as NoColumn, updateddate
	FROM search1 AS s 
	LEFT JOIN search_pics AS sp 
	ON s.id=sp.shid ) dt
ORDER BY updateddate DESC

Ja, det framgick ju nästan av felmeddelandet ...