File: sqlpq92.sql

package info (click to toggle)
a2ps 1%3A4.14-2
  • links: PTS
  • area: main
  • in suites: stretch
  • size: 13,328 kB
  • sloc: ansic: 26,966; sh: 11,844; lex: 2,286; perl: 1,156; yacc: 757; makefile: 609; lisp: 398; ada: 263; objc: 189; f90: 109; ml: 85; sql: 74; pascal: 57; modula3: 33; haskell: 32; sed: 30; java: 29; python: 24
file content (5 lines) | stat: -rw-r--r-- 115 bytes parent folder | download | duplicates (15) 
1
2
3
4
5
 
SELECT H.emp_no, 
       H.hist_type,
       count(*)  
FROM   emp_history H
GROUP  BY H.emp_no, H.hist_type;