SAP 7090310 Scheda Tecnica Pagina 541

  • Scaricare
  • Aggiungi ai miei manuali
  • Stampa
  • Pagina
    / 706
  • Indice
  • SEGNALIBRI
  • Valutato. / 5. Basato su recensioni clienti
Vedere la pagina 540
The result set from a Greater Than Or Equal link includes all records in which the linked field value in
the primary table is greater than or equal to the linked field value in the lookup table. The example here
is identical to the example for the Greater Than join, except that it uses the Greater Than Or Equal link:
SELECT SalesRep.'Last Name',
SalesRep.'Salary',
Manager.'Last Name',
Manager.'Salary'
FROM 'SalesRep' SalesRep,
'Manager' Manager
WHERE SalesRep.'Salary' >=
Manager.'Salary'
This statement might produce data such as this:
Manager TableManager TableSalesRep TableSalesRep Table
SalaryLast NameSalaryLast Name
$32,000.00Fuller$35,000.00Davolio
$30,000.00Brid$35,000.00Davolio
$29,500.00Buchanan$35,000.00Davolio
$35,000.00Martin$35,000.00Davolio
$45,000.00Hellstern$48,300.00Dodsworth
$32,000.00Fuller$48,300.00Dodsworth
$30,000.00Brid$48,300.00Dodsworth
$29,500.00Buchanan$48,300.00Dodsworth
$35,000.00Martin$48,300.00Dodsworth
$30,000.00Brid$30,000.00Patterson
$29,500.00Buchanan$30,000.00Patterson
2011-05-16541
Understanding Databases
Vedere la pagina 540
1 2 ... 536 537 538 539 540 541 542 543 544 545 546 ... 705 706

Commenti su questo manuale

Vikixwk 04 Jan 2024 | 13:20:14

urenrjrjkvnm

Viktorihon 14 Jan 2024 | 00:44:53

Cinema