SELECT g.G6_DETECTION_ID G6_DETECTION_ID, t.veh_clzzqymc sccmc, t.veh_clxh vehicle_model, g.VIN VIN, t.VIN TVIN, tt.VIN TTVIN, tt.CAR_TYPE CARTYPE, tt.XXGKBH XXGKBH, t.VEH_CLPP SB, t.VEH_CPSCDZ SCCDZ, to_char( t.VEH_CLSCRQ, 'yyyy"年"mm"月"dd"日"' ) SCDATE, t.VEH_FDJH FDJH, g.FDJSB FDJSB, g.FDJSCCDZ FDJSCCDZ, g.RH RH, g.ET ET, g.AP AP, g.TESTTYPE TEST_TYPE, g.TESTNO TESTNO, g.TESTDATE TEST_DATE, g.APASS APASS, g.OPASS OPASS, g.OTESTDATE OTESTDATE, g.EPASS EPASS, g.RESULT RESULT, g.YR YR, g.ANALYMANUF ANALYMANUF, g.ANALYNAME ANALYNAME, g.ANALYMODEL ANALYMODEL, g.ANALYDATE ANALYDATE, g.DYNOMODEL DYNOMODEL, g.DYNOMANUF DYNOMANUF, g.ISUPLOAD ISUPLOAD, g.UPLOADDATE UPLOADDATE, g.ISUPLOADSECCESS ISUPLOADSECCESS, g.UPLOADUSER UPLOADUSER, g.UPLOADPERSON UPLOADPERSON, g.UPLOADMES UPLOADMES, g.ISAUTOUPLOAD, t.is_sample ISSAMPLE, t.FRIST_PRINT_DATE BANCI, g.OBDINSPECTOR, SUBSTR( g.VIN, 8, 1 ) AS DLLX, T_DLLX.NAME AS DLLXNAME FROM G6_DETECTION_RESULT g LEFT JOIN T_VEHCERT_PRINT t ON g.VIN = t.VIN LEFT JOIN T_HBBQ_PRINT tt ON g.VIN = tt.VIN LEFT JOIN T_DLLX ON SUBSTR( g.VIN, 8, 1 ) = T_DLLX.CODE WHERE tt.car_type!='E' 通过car_type预期查询出来应该有一条数据,但是结果因为这条数据car_type为空被自动去除了,如何让他不自动去除
时间: 2024-02-21 08:00:51 浏览: 33
可以改为使用 "IS NOT NULL" 条件来筛选非空值,例如将 WHERE 子句改为:
```
WHERE tt.car_type IS NOT NULL AND tt.car_type != 'E'
```
这样可以保留 car_type 为空的数据,同时排除 car_type 为 'E' 的数据。
相关问题
SELECT g.G6_DETECTION_ID G6_DETECTION_ID, t.veh_clzzqymc sccmc, t.veh_clxh vehicle_model, g.VIN VIN, t.VIN TVIN, tt.VIN TTVIN, tt.CAR_TYPE CARTYPE, tt.XXGKBH XXGKBH, t.VEH_CLPP SB, t.VEH_CPSCDZ SCCDZ, to_char( t.VEH_CLSCRQ, 'yyyy"年"mm"月"dd"日"' ) SCDATE, t.VEH_FDJH FDJH, g.FDJSB FDJSB, g.FDJSCCDZ FDJSCCDZ, g.RH RH, g.ET ET, g.AP AP, g.TESTTYPE TEST_TYPE, g.TESTNO TESTNO, g.TESTDATE TEST_DATE, g.APASS APASS, g.OPASS OPASS, g.OTESTDATE OTESTDATE, g.EPASS EPASS, g.RESULT RESULT, g.YR YR, g.ANALYMANUF ANALYMANUF, g.ANALYNAME ANALYNAME, g.ANALYMODEL ANALYMODEL, g.ANALYDATE ANALYDATE, g.DYNOMODEL DYNOMODEL, g.DYNOMANUF DYNOMANUF, g.ISUPLOAD ISUPLOAD, g.UPLOADDATE UPLOADDATE, g.ISUPLOADSECCESS ISUPLOADSECCESS, g.UPLOADUSER UPLOADUSER, g.UPLOADPERSON UPLOADPERSON, g.UPLOADMES UPLOADMES, g.ISAUTOUPLOAD, t.is_sample ISSAMPLE, t.FRIST_PRINT_DATE BANCI, g.OBDINSPECTOR, SUBSTR( g.VIN, 8, 1 ) AS DLLX, T_DLLX.NAME AS DLLXNAME FROM G6_DETECTION_RESULT g LEFT JOIN T_VEHCERT_PRINT t ON g.VIN = t.VIN LEFT JOIN T_HBBQ_PRINT tt ON g.VIN = tt.VIN LEFT JOIN T_DLLX ON SUBSTR( g.VIN, 8, 1 ) = T_DLLX.CODE WHERE tt.car_type!='E' 通过car_type查询出来的数据应该有五条,但是自动去除car_type为空的四条数据,怎么做可以不去掉这四条数据
你可以使用以下 SQL 语句来查询出所有的数据,包括 car_type 为空的数据:
```
SELECT
g.G6_DETECTION_ID G6_DETECTION_ID,
t.veh_clzzqymc sccmc,
t.veh_clxh vehicle_model,
g.VIN VIN,
t.VIN TVIN,
tt.VIN TTVIN,
tt.CAR_TYPE CARTYPE,
tt.XXGKBH XXGKBH,
t.VEH_CLPP SB,
t.VEH_CPSCDZ SCCDZ,
to_char(t.VEH_CLSCRQ, 'yyyy"年"mm"月"dd"日"') SCDATE,
t.VEH_FDJH FDJH,
g.FDJSB FDJSB,
g.FDJSCCDZ FDJSCCDZ,
g.RH RH,
g.ET ET,
g.AP AP,
g.TESTTYPE TEST_TYPE,
g.TESTNO TESTNO,
g.TESTDATE TEST_DATE,
g.APASS APASS,
g.OPASS OPASS,
g.OTESTDATE OTESTDATE,
g.EPASS EPASS,
g.RESULT RESULT,
g.YR YR,
g.ANALYMANUF ANALYMANUF,
g.ANALYNAME ANALYNAME,
g.ANALYMODEL ANALYMODEL,
g.ANALYDATE ANALYDATE,
g.DYNOMODEL DYNOMODEL,
g.DYNOMANUF DYNOMANUF,
g.ISUPLOAD ISUPLOAD,
g.UPLOADDATE UPLOADDATE,
g.ISUPLOADSECCESS ISUPLOADSECCESS,
g.UPLOADUSER UPLOADUSER,
g.UPLOADPERSON UPLOADPERSON,
g.UPLOADMES UPLOADMES,
g.ISAUTOUPLOAD,
t.is_sample ISSAMPLE,
t.FRIST_PRINT_DATE BANCI,
g.OBDINSPECTOR,
SUBSTR(g.VIN, 8, 1) AS DLLX,
T_DLLX.NAME AS DLLXNAME
FROM
G6_DETECTION_RESULT g
LEFT JOIN T_VEHCERT_PRINT t ON g.VIN = t.VIN
LEFT JOIN T_HBBQ_PRINT tt ON g.VIN = tt.VIN
LEFT JOIN T_DLLX ON SUBSTR(g.VIN, 8, 1) = T_DLLX.CODE
WHERE
tt.car_type != 'E' OR tt.car_type IS NULL
```
这样就可以保留 car_type 为空的数据了。
SELECT * FROM ( SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( SELECT tt.ID, tt.VIN, tt.AON, tt.MSC, tt.VEH_CLSCRQ, tt.COLOR_CODE, tt.VEH_ZCHGZBH, tt.VEH_WZHGZBH, tt.VEH_FZRQ, tt.FRIST_PRINT_DATE, tt.VEH_CLZZQYMC, tt.VEH_CLPPMC, tt.IFLOCK, tt.UP_SYNCSTATE, tt.VEH_CLXH, tt.IS_SAMPLE, ta.XNYC AS XNYC, SUBSTR( VIN, 8, 1 ) AS DLLX, T_DLLX.NAME AS DLLXNAME FROM T_VEHCERT_PRINT tt LEFT JOIN T_ALL_PARAM ta ON tt.MSC = ta.MSC LEFT JOIN T_DLLX ON SUBSTR( VIN, 8, 1 ) = T_DLLX.CODE WHERE XNYC = '否' AND IFLOCK = '0' AND UP_SYNCSTATE ='1' ORDER BY frist_print_date DESC ) TMP_PAGE WHERE ROWNUM <= '10' ) WHERE ROW_ID > '0'这段sql查询半天都查不出结果
这段 SQL 查询语句的目的是从 T_VEHCERT_PRINT 表中选择一些列,并将它们与其他表连接,然后按照 frist_print_date 字段降序排序。然后,它将结果限制为前 10 行,并为每一行分配一个 ROW_ID。最后,它选择所有 ROW_ID 大于 0 的行。
如果这段 SQL 查询半天都查不出结果,可能是因为没有符合条件的数据存在。您可以检查 WHERE 子句中的条件是否正确,并检查表中是否存在与这些条件匹配的数据。此外,您还可以查看数据库日志,以查找是否存在任何错误或异常。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)