对于大多数具有不同价值的候选人,我有一个以上的记录。表中给出的例子。我想只为每一个获得一条记录。我用过...... [英] I have aquery where there are more then one record for most of the candidates with different value . The example given in the table. I want to get one record for each one only .I have used...
问题描述
col1 col2 col3 col4 col5
enrolid candidatename applicationstatus coursecode coursetype
001 abc已注册001全时
001 abc applicationwithdrwan 001 fulltime
002 bbc已登记003 partime
003 cde已注册004全日制
如何进一步删除或过滤它,每个只能看到一个名称而不是多个
你必须在SQL查询中使用Normalization。根据规范化概念拆分你的表格。
查看以下链接。
http://www.dotnet-tricks.com/Tutorial/sqlserver/756N210512-Database-Normalization-Basics.html [ ^ ] < br $> b $ b
http://www.studytonight.com/dbms /database-normalization.php [ ^
col1 col2 col3 col4 col5
enrolid candidatename applicationstatus coursecode coursetype
001 abc enrolled 001 fulltime
001 abc applicationwithdrwan 001 fulltime
002 bbc enrolled 003 partime
003 cde enrolled 004 fulltime
How can i remove or filter it further to see only one name for each one not multiple
You have to use the Normalization in your SQL query. Split your table based on the Normalization concept.
check the below links.
http://www.dotnet-tricks.com/Tutorial/sqlserver/756N210512-Database-Normalization-Basics.html[^]
http://www.studytonight.com/dbms/database-normalization.php[^]
这篇关于对于大多数具有不同价值的候选人,我有一个以上的记录。表中给出的例子。我想只为每一个获得一条记录。我用过......的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!