File: tablesample.expect.txt

package info (click to toggle)
highlight.js 9.18.5%2Bdfsg1-1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 6,672 kB
  • sloc: javascript: 40,928; python: 342; makefile: 160; sh: 11
file content (5 lines) | stat: -rw-r--r-- 763 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
 
<span class="hljs-keyword">SELECT</span> * <span class="hljs-keyword">FROM</span> orders <span class="hljs-keyword">TABLESAMPLE</span> (<span class="hljs-number">500</span> <span class="hljs-keyword">ROWS</span>);

<span class="hljs-keyword">SELECT</span> * <span class="hljs-keyword">FROM</span> customers <span class="hljs-keyword">TABLESAMPLE</span> (<span class="hljs-number">25</span> <span class="hljs-keyword">PERCENT</span>);

<span class="hljs-keyword">SELECT</span> * <span class="hljs-keyword">FROM</span> employees <span class="hljs-keyword">TABLESAMPLE</span> (<span class="hljs-keyword">BUCKET</span> <span class="hljs-number">2</span> <span class="hljs-keyword">OUT</span> <span class="hljs-keyword">OF</span> <span class="hljs-number">10</span>);