I want to select top 10 distinct exposureids

[ASmee]

The following command does not work:

select top 10 (distinct(exposureid)) from iinstrumentid

The table contains duplicate exposureids, so all I want are the top 10 distinct exposureids.

 

[ASmee]

the answers is.....

select distinct(exposureid) from iinstrumentidmaster where exposureid in (select top 10 exposureid from iinstrumentidmaster)

 

[Sabnac]

In this case, you will have the distinct value of the 10 top rows. If the top 10 rows are the same you will get 1 rows.

Try this :
SELECT TOP 10 exposureid
FROM iinstrumentid
GROUP BY exposureid

 

[SQLSister]

Did you try:
Select distinct top 10 exposureid from instrumentid

 

[LokiDba]

You could also try

SET ROWCOUNT 10 -- Return only the first 10 rows

SELECT DISTINCT exposureid
FROM instrumentid

SET ROWCOOUNT 0 -- Reset row count to all


Hope of some use

Andy (LokiDBA)