<div>
order by the upload_date <br />
you can then get the 10 latest (or earliest)
</div>


<div>
or<br />
select top 10 * from<br />
(select distinct blah blah from tableName order by upload_date)<br />
order by id desc
</div>


<div>
SELECT top 10 image_id, id, diy_variables, publish, upload_date, frame, member_id<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table1<br />
group by image_id, id, diy_variables, publish, upload_date, frame, member_id<br />
ORDER BY id DESC
</div>


<div>
tried but both doesnt work. Guru, the query says it has syntax error. HuyBD, no syntax error but it doesnt selects out the distinct ones, the result is just same a normal select top 10 *....
</div>


<div>
huang_ck! what is field you want to select distinct, all or only one field
</div>


<div>
sorry guys, my query was a bit wrong, actually i want to select the latest top 10 group by image_id, in mysql I would write like this:<br />
<br />
SELECT image_id, id, diy_variables, publish, upload_date, frame, member_id<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table1<br />
group by image_id<br />
ORDER BY id DESC<br />
limit 10<br />
<br />
in sql server the syntax isn't like this, but the above i tried doesn't work, I need to know a way of getting the top 10 latest unique records group by image_id, I just dont know how. These doesnt work too:<br />
<br />
SELECT &nbsp; top 10 &nbsp;image_id, id, diy_variables, publish, upload_date, frame, member_id<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table1<br />
GROUP BY &nbsp;image_id<br />
<br />
SELECT top 10 image_id, id, diy_variables, publish, upload_date, frame, member_id<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table1<br />
group by image_id<br />
ORDER BY id DESC
</div>


<div>
<div class="content wysiwyg-content">
I have a sql server query:<br />
<br />
SELECT DISTINCT <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; image_id, id, diy_variables, publish, upload_date, frame, member_id<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table1<br />
ORDER BY id DESC<br />
<br />
I need to select the latest 10 records and I tried:<br />
SELECT TOP 10 (DISTINCT image_id, id, diy_variables, publish, upload_date, frame, member_id) .....<br />
SELECT TOP 10 DISTINCT image_id, id, diy_variables, publish, upload_date, frame, member_id .....<br />
<br />
both doesnt work, what is the correct syntax to do so? Isn't it something like SELECT TOP 10 * ......
</div>
</div>


I have a sql server query:

SELECT DISTINCT 
                          image_id, id, diy_variables, publish, upload_date, frame, member_id
FROM            table1
ORDER BY id DESC

I need to select the latest 10 records and I tried:
SELECT TOP 10 (DISTINCT image_id, id, diy_variables, publish, upload_date, frame, member_id) .....
SELECT TOP 10 DISTINCT image_id, id, diy_variables, publish, upload_date, frame, member_id .....

both doesnt work, what is the correct syntax to do so? Isn't it something like SELECT TOP 10 * ......

sql server query to select the latest records with distinct

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.