How to reduce duplicate data from a recordset

How to reduce duplicate data from a recordset

To reduce duplicate data from a recordset

You can reduce duplication in your data through the use of DISTINCT in your SELECT statement.

<%

set conn=Server.CreateObject("ADODB.Connection")

conn.Open "DSN=tenderproject;UID=tenderproject;PWD=tender"

set rs=Server.CreateObject("ADODB.Recordset")

sqlstr = "SELECT DISTINCT name, expertise from mytable ORDER BY name "

rs.open sqlstr, conn, 1,3

%>

Edited By: Norasyikin Mahmud

© 2001 ISC/Inner Esteem

All rights reserved. All other product names and trademarks are registered properties of their respective owners.

140302