从sql填写下拉列表 [英] Fill Dropdown list from sql

问题描述

F_NAME的列有很多次名称，我想在下拉列表中显示名称一次。

  SELECT  FID，F_NAME  FROM  tblFDetail 
 在哪里 F_Name<> F_Name 

显示空结果。

tblFDetail表是



FID       F_NAME

1         osity

2         osity

3         mutim

4         fdyim

5         mutim

解决方案

你得到一个空结果的原因是因为你使用的条件（WHERE F_Name<> F_Name）永远不会是真的 - 你有效地试图说这个列不包含它包含的值

获取sql中唯一名称的列表

  SELECT   DISTINCT  F_Name  FROM  tblFDetail 

Column of F_NAME have same "name" many time, i want to show that "name" one time in dropdown list.

SELECT FID, F_NAME FROM tblFDetail
WHERE F_Name <> F_Name

it show empty result.
tblFDetail table is

FID      F_NAME
1        osity
2        osity
3        mutim
4        fdyim
5        mutim

解决方案

The reason you''re getting an empty result is because the condition you used ("WHERE F_Name <> F_Name") could never be true - you''re effectively trying to say "where this column does not contain the value it does contain"
To get the list of unique names in sql

SELECT DISTINCT F_Name FROM tblFDetail

这篇关于从sql填写下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！