UC知道sql语言查询
来源：百度知道 编辑：UC知道 时间：2024/06/16 23:41:14
CREATE VIEW DIS(CUSTOMER,CX,CY,CUSTOMER,CX,CY)
AS
SELECT FIRST.CUSTOMER,CX,CY,SECOND.CUSTOMER,CX,CY
FROM CUSTOMER FIRST,CUSTOMER SECOND
WHERE 4*sin((FIRST.CX-SECOND.CX)/360*PI)*sin((FIRST.CX-SECOND.CX)/360*PI)+
(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))*(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))
>=ALL
SELECT 4*sin((FIRST.CX-SECOND.CX)/360*PI)*sin((FIRST.CX-SECOND.CX)/360*PI)+
(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))*(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))
FROM CUSTOMER FIRST,CUSTOMER SECOND;
就是给出一个视图，里面两个人的距离最远
cx，cy是经纬度，不知以上语句怎么错了
AS
SELECT FIRST.CUSTOMER,CX,CY,SECOND.CUSTOMER,CX,CY
FROM CUSTOMER FIRST,CUSTOMER SECOND
WHERE 4*sin((FIRST.CX-SECOND.CX)/360*PI)*sin((FIRST.CX-SECOND.CX)/360*PI)+
(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))*(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))
>=ALL
SELECT 4*sin((FIRST.CX-SECOND.CX)/360*PI)*sin((FIRST.CX-SECOND.CX)/360*PI)+
(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))*(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))
FROM CUSTOMER FIRST,CUSTOMER SECOND;
就是给出一个视图，里面两个人的距离最远
cx，cy是经纬度，不知以上语句怎么错了
CREATE VIEW DIS(CUSTOMER,CX,CY,CUSTOMER,CX,CY)
AS
SELECT FIRST.CUSTOMER,FIRST.CX,FIRST.CY,SECOND.CUSTOMER,SECOND.CX,SECOND.CY
FROM CUSTOMER FIRST,CUSTOMER SECOND
WHERE 4*sin((FIRST.CX-SECOND.CX)/360*PI)*sin((FIRST.CX-SECOND.CX)/360*PI)+
(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))*(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))
>=ALL
SELECT 4*sin((FIRST.CX-SECOND.CX)/360*PI)*sin((FIRST.CX-SECOND.CX)/360*PI)+
(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))*(SIN(FIRST.CY/180*PI)-SIN(SECOND.CY/180*PI))
FROM CUSTOMER FIRST,CUSTOMER SECOND;
这个最好用空间数据库
第一行的CX,CY没有指定是哪张表的字段，所以会出错，在字段名前加表的别名试一下看看