EXECSQL Merge Example

Query Status

35 rows were fetched by execution of the query:

select * from q.staff

Column Information

There are 7 columns in each result set row. The column names are:

• ID
• NAME
• DEPT
• JOB
• YEARS
• SALARY
• COMM

Result Set Row Data

Result Set Data formatted as a list is:

• Result Row 1:
  • ID = 10
  • NAME = SANDERS
  • DEPT = 20
  • JOB = MGR
  • YEARS = 7
  • SALARY = 18357.50
  • COMM =

• Result Row 2:
  • ID = 20
  • NAME = PERNAL
  • DEPT = 20
  • JOB = SALES
  • YEARS = 8
  • SALARY = 18171.25
  • COMM = 612.45

• Result Row 3:
  • ID = 30
  • NAME = MARENGHI
  • DEPT = 38
  • JOB = MGR
  • YEARS = 5
  • SALARY = 17506.75
  • COMM =

• Result Row 4:
  • ID = 40
  • NAME = O'BRIEN
  • DEPT = 38
  • JOB = SALES
  • YEARS = 6
  • SALARY = 18006.00
  • COMM = 846.55

• Result Row 5:
  • ID = 50
  • NAME = HANES
  • DEPT = 15
  • JOB = MGR
  • YEARS = 10
  • SALARY = 20659.80
  • COMM =

• Result Row 6:
  • ID = 60
  • NAME = QUIGLEY
  • DEPT = 38
  • JOB = SALES
  • YEARS =
  • SALARY = 16808.30
  • COMM = 650.25

• Result Row 7:
  • ID = 70
  • NAME = ROTHMAN
  • DEPT = 15
  • JOB = SALES
  • YEARS = 7
  • SALARY = 16502.83
  • COMM = 1152.00

• Result Row 8:
  • ID = 80
  • NAME = JAMES
  • DEPT = 20
  • JOB = CLERK
  • YEARS =
  • SALARY = 13504.60
  • COMM = 128.20

• Result Row 9:
  • ID = 90
  • NAME = KOONITZ
  • DEPT = 42
  • JOB = SALES
  • YEARS = 6
  • SALARY = 18001.75
  • COMM = 1386.70

• Result Row 10:
  • ID = 100
  • NAME = PLOTZ
  • DEPT = 42
  • JOB = MGR
  • YEARS = 7
  • SALARY = 18352.80
  • COMM =

• Result Row 11:
  • ID = 110
  • NAME = NGAN
  • DEPT = 15
  • JOB = CLERK
  • YEARS = 5
  • SALARY = 12508.20
  • COMM = 206.60

• Result Row 12:
  • ID = 120
  • NAME = NAUGHTON
  • DEPT = 38
  • JOB = CLERK
  • YEARS =
  • SALARY = 12954.75
  • COMM = 180.00

• Result Row 13:
  • ID = 130
  • NAME = YAMAGUCHI
  • DEPT = 42
  • JOB = CLERK
  • YEARS = 6
  • SALARY = 10505.90
  • COMM = 75.60

• Result Row 14:
  • ID = 140
  • NAME = FRAYE
  • DEPT = 51
  • JOB = MGR
  • YEARS = 6
  • SALARY = 21150.00
  • COMM =

• Result Row 15:
  • ID = 150
  • NAME = WILLIAMS
  • DEPT = 51
  • JOB = SALES
  • YEARS = 6
  • SALARY = 19456.50
  • COMM = 637.65

• Result Row 16:
  • ID = 160
  • NAME = MOLINARE
  • DEPT = 10
  • JOB = MGR
  • YEARS = 7
  • SALARY = 22959.20
  • COMM =

• Result Row 17:
  • ID = 170
  • NAME = KERMISCH
  • DEPT = 15
  • JOB = CLERK
  • YEARS = 4
  • SALARY = 12258.50
  • COMM = 110.10

• Result Row 18:
  • ID = 180
  • NAME = ABRAHAMS
  • DEPT = 38
  • JOB = CLERK
  • YEARS = 3
  • SALARY = 12009.75
  • COMM = 236.50

• Result Row 19:
  • ID = 190
  • NAME = SNEIDER
  • DEPT = 20
  • JOB = CLERK
  • YEARS = 8
  • SALARY = 14252.75
  • COMM = 126.50

• Result Row 20:
  • ID = 200
  • NAME = SCOUTTEN
  • DEPT = 42
  • JOB = CLERK
  • YEARS =
  • SALARY = 11508.60
  • COMM = 84.20

• Result Row 21:
  • ID = 210
  • NAME = LU
  • DEPT = 10
  • JOB = MGR
  • YEARS = 10
  • SALARY = 20010.00
  • COMM =

• Result Row 22:
  • ID = 220
  • NAME = SMITH
  • DEPT = 51
  • JOB = SALES
  • YEARS = 7
  • SALARY = 17654.50
  • COMM = 992.80

• Result Row 23:
  • ID = 230
  • NAME = LUNDQUIST
  • DEPT = 51
  • JOB = CLERK
  • YEARS = 3
  • SALARY = 13369.80
  • COMM = 189.65

• Result Row 24:
  • ID = 240
  • NAME = DANIELS
  • DEPT = 10
  • JOB = MGR
  • YEARS = 5
  • SALARY = 19260.25
  • COMM =

• Result Row 25:
  • ID = 250
  • NAME = WHEELER
  • DEPT = 51
  • JOB = CLERK
  • YEARS = 6
  • SALARY = 14460.00
  • COMM = 513.30

• Result Row 26:
  • ID = 260
  • NAME = JONES
  • DEPT = 10
  • JOB = MGR
  • YEARS = 12
  • SALARY = 21234.00
  • COMM =

• Result Row 27:
  • ID = 270
  • NAME = LEA
  • DEPT = 66
  • JOB = MGR
  • YEARS = 9
  • SALARY = 18555.50
  • COMM =

• Result Row 28:
  • ID = 280
  • NAME = WILSON
  • DEPT = 66
  • JOB = SALES
  • YEARS = 9
  • SALARY = 18674.50
  • COMM = 811.50

• Result Row 29:
  • ID = 290
  • NAME = QUILL
  • DEPT = 84
  • JOB = MGR
  • YEARS = 10
  • SALARY = 19818.00
  • COMM =

• Result Row 30:
  • ID = 300
  • NAME = DAVIS
  • DEPT = 84
  • JOB = SALES
  • YEARS = 5
  • SALARY = 15454.50
  • COMM = 806.10

• Result Row 31:
  • ID = 310
  • NAME = GRAHAM
  • DEPT = 66
  • JOB = SALES
  • YEARS = 13
  • SALARY = 21000.00
  • COMM = 200.30

• Result Row 32:
  • ID = 320
  • NAME = GONZALES
  • DEPT = 66
  • JOB = SALES
  • YEARS = 4
  • SALARY = 16858.20
  • COMM = 844.00

• Result Row 33:
  • ID = 330
  • NAME = BURKE
  • DEPT = 66
  • JOB = CLERK
  • YEARS = 1
  • SALARY = 10988.00
  • COMM = 55.50

• Result Row 34:
  • ID = 340
  • NAME = EDWARDS
  • DEPT = 84
  • JOB = SALES
  • YEARS = 7
  • SALARY = 17844.00
  • COMM = 1285.00

• Result Row 35:
  • ID = 350
  • NAME = GAFNEY
  • DEPT = 84
  • JOB = CLERK
  • YEARS = 5
  • SALARY = 13030.50
  • COMM = 188.00