Oracle

Guidelines for using subquery

Figo Kim 2006. 9. 1. 20:22
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
  • Enclose subqueries in parantheses.
  • Place subqueries on the right side of the comparison condition.
  • The ORDER BY clause in the subquery is not needed unless you re performing TOP-N analysis.
  • Using single-row operators with single-row subqueries, and use multiple-row operators with multiple-row subqueries.

'Oracle' 카테고리의 다른 글

Multiple operator..  (0) 2006.09.01
Guidelines for using subquery  (0) 2006.09.01
Subquery Syntax  (0) 2006.09.01
Subquery Syntax  (0) 2006.09.01
Cartesian product.  (0) 2006.09.01