SAP 7090310 Datenblatt Seite 542

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 706
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 541
23.5.10.12 Less Than [<] link
The result set from a Less Than link includes all records in which the linked field value in the primary
table is less than the linked field value in the lookup table. Using the Less Than link, you can compare
sales representative and manager salaries in a different direction. Once again, the Salary field in each
table is used as the link field. This time, though, you link from the Manager table to the SalesRep table
using a Less Than link on the linked Salary fields:
SELECT Manager.'Last Name',
Manager.'Salary',
SalesRep.'Last Name',
SalesRep.'Salary'
FROM 'Manager' Manager,
'SalesRep' SalesRep
WHERE Manager.'Salary' <
SalesRep.'Salary'
This SQL statement produces a slightly different table than that produced by the Greater Than link:
SalesRep TableSalesRep TableManager TableManager Table
SalaryLast NameSalaryLast Name
$35,000.00Davolio$32,000.00Fuller
$48,300.00Dodsworth$32,000.00Fuller
$35,000.00Davolio$30,000.00Brid
$48,300.00Dodsworth$30,000.00Brid
$35,000.00Davolio$29,500.00Buchanan
$48,300.00Dodsworth$29,500.00Buchanan
$30,000.00Patterson$29,500.00Buchanan
$48,300.00Dodsworth$35,000.00Martin
$48,300.00Dodsworth$45,000.00Hellstern
2011-05-16542
Understanding Databases
Seitenansicht 541
1 2 ... 537 538 539 540 541 542 543 544 545 546 547 ... 705 706

Kommentare zu diesen Handbüchern

Vikixwk 04 Jan 2024 | 13:20:14

urenrjrjkvnm

Viktorihon 14 Jan 2024 | 00:44:53

Cinema