sql conversion hql left join problem

I do not know the following sql statement on how this form of written hql

select count (*) from (select rydm from pj_jbr t where iyear = 2010 and imonth = 4
and rydm not in (
select rydm from pb_ryjxbase t where status = '1 ')) b
left join (select rydm_out, sum (zy_rate) zy_rate from pb_zhuanyi t
group by rydm_out)
a
on a.rydm_out = b.rydm where a.zy_rate <100 or a.zy_rate is null

分类:Java 时间:2010-05-12 人气:243
本文关键词: lt sql statement conversion pj jbr
分享到:
blog comments powered by Disqus

相关文章

  • Conversion and other classic SQL statement in the ranks 2010-11-17

    1. - Ranks of the conversion of the original table: Name of course result Joe Smith 80 languages Zhang San Mathematics 90 Zhang San Physics 85 John Doe 85 languages Physics 82 John Doe John Doe English 90 70 John Doe Politics Wang Wuying 90 words Con

  • ORACLE SQL statement optimization summarized in 2010-02-23

    ORACLE SQL statement optimization summarized in (1) Select the most efficient sequence table name (only the effective rule-based optimizer): ORACLE parser in accordance with the order processing from right to left in the FROM clause of the table name

  • ORACLE database SQL statement optimization techniques 2010-03-15

    ORACLE database SQL statement optimization techniques: IN operator IN written with the advantages of SQL is easier to write and clear easy to understand, is more suitable for modern software development style. However, the SQL performance with IN is

  • Optimization of SQL statement based on the index of 2010-03-15

    1 Introduction 2 2 Master 2 3 Eighteen 3 The first metacarpal to avoid the operation of the column 3 The second metacarpal to avoid unnecessary type conversions 4 The third metacarpal increased to limit the query 4 Get rid of the fourth metacarpal as

  • Very useful SQL statement optimization 34 2010-05-11

    1) Select the most efficient sequence table name (only the effective rule-based optimizer): ORACLE parser according to the order processing from right to left the table name FROM clause, FROM clause written in the final table (base table driving tabl

  • Analysis of the implementation plan optimization SQL <1> --- SQL statement processing process (transfer) 2010-05-27

    Chapter 1 SQL statement before processing the adjustment process we need to know some background knowledge, and only know the background, we can better to adjust the sql statement. This section describes the basic process of dealing with SQL statemen

  • oracle sql statement Jingjiang 2010-06-12

    Table: A table refers primarily to define the following information: Column table where the table definition of integrity constraints, optional space to store the characteristics of access to data gathered from a query syntax is as follows: CREATE TA

  • SQL statement Daquan 2010-06-23

    Basis Create Database Create the database before the judge whether there if exists (select * from sysdatabases where name = 'databaseName') drop database 'databaseName' go Create DATABASE database-name Delete Database drop database dbname Backup sql

  • mysql dump.sql case conversion 2010-06-24

    Case: Export from the company's mysql database, in linux and into the mysql, sql statement application case led to the problem: Export mysql (windows): mysqldump-h host-u userName-p password> dump.sql Under linux into mysql: mysql-u root-p mysql> so

  • Reposted elsewhere - by analyzing the SQL statement execution plan optimization of SQL (summary) 2010-06-30

    By analyzing the SQL statement execution plan optimization of SQL (summary) DBA did almost 7 years, and sentiment among many. In the DBA's daily work, to adjust individual performance to a less challenging when the SQL statement of work. The key lies

iOS 开发

Android 开发

Python 开发

JAVA 开发

开发语言

PHP 开发

Ruby 开发

搜索

前端开发

数据库

开发工具

开放平台

Javascript 开发

.NET 开发

云计算

服务器

Copyright (C) codeweblog.com, All Rights Reserved.

CodeWeblog.com 版权所有 黔ICP备15002463号-1

processed in 0.103 (s). 12 q(s)