tyneet Posted October 12, 2005 Share Posted October 12, 2005 Does anyone know if I can use the SELECT DISTINCT on part of a column field or does it have to be the entire field?Thanks. Link to comment Share on other sites More sharing options...
actionsketch Posted October 13, 2005 Share Posted October 13, 2005 interesting question... maybe. Have you tried something like:SELECT DISTINCT w3blah*FROM table_nameI doubt it'll work but it might... the * meaning wild card Link to comment Share on other sites More sharing options...
maelstorm Posted October 14, 2005 Share Posted October 14, 2005 i guess SELECT DISTINCT can only be used for the entire record and not on individual fields.. Does anyone know if I can use the SELECT DISTINCT on part of a column field or does it have to be the entire field?Thanks.<{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
The-Eagle-Eye Posted October 18, 2005 Share Posted October 18, 2005 i guess SELECT DISTINCT can only be used for the entire record and not on individual fields..<{POST_SNAPBACK}> Does anyone know if I can use the SELECT DISTINCT on part of a column field or does it have to be the entire field?Thanks. select distinct can be used for individual field (column) but default it goes for all the rows in that field.If u want it for a part of a filed, neccesary where condition has to be given. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now