请使用oracle(sql)回答此查询 [英] plz answet this query using oracle(sql)

问题描述

我在名为tbl_country的表中有一个名为country的列.
一栏中有四个国家，分别为印度，巴基斯坦，澳大利亚和孟加拉德什.
所以我们必须找出印度，巴基斯坦，澳大利亚和孟加拉德什之间的数学关系.每个国家只能与每个国家玩一次.

条件-----如果印度诗与巴基斯坦比赛将显示，那么巴基斯坦诗经印度比赛将不会显示.请为此编写查询.请回复

i have one column named country in a table named as tbl_country.
There are four country in a column named india,pakistan,austrilya and bangla desh.
so we have to find out the math betwee india,pakistan,austrilya and bangla desh. Each country play only once with each country.

condition----- If india verses pakstan match will show then pakisthan verses india match will not show. please write the query for this. please reply

推荐答案

我在名为tbl_country的表中有一个名为country的列.
一栏中有四个国家，分别为印度，巴基斯坦，澳大利亚和孟加拉德什.
所以我们必须找出印度，巴基斯坦，澳大利亚和孟加拉德什之间的数学关系.每个国家只能与每个国家玩一次.

条件-----如果印度诗与巴基斯坦比赛将显示，那么巴基斯坦诗经印度比赛将不会显示.请为此编写查询.

i have one column named country in a table named as tbl_country.
There are four country in a column named india,pakistan,austrilya and bangla desh.
so we have to find out the math betwee india,pakistan,austrilya and bangla desh. Each country play only once with each country.

condition----- If india verses pakstan match will show then pakisthan verses india match will not show. please write the query for this.

这篇关于请使用oracle(sql)回答此查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！