SAP 7090310 Datový list Strana 542

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 706
  • Tabulka s obsahem
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 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
Zobrazit stránku 541
1 2 ... 537 538 539 540 541 542 543 544 545 546 547 ... 705 706

Komentáře k této Příručce

Vikixwk 04 Jan 2024 | 13:20:14

urenrjrjkvnm

Viktorihon 14 Jan 2024 | 00:44:53

Cinema