Databases Searching and Sorting


Download 446 b.
Sana14.08.2018
Hajmi446 b.


Databases


SIMPLE search



COMPLEX search



Examples of Simple searches

  • Eye Colour = “Blue”

  • Country = “Italy”

  • Language = “Spanish”

  • Stays in = “Lochwinnoch”

  • Anything that uses just ONE field in a database is a SIMPLE search



More SIMPLE searches



More COMPLEX searches

  • Eye colour = “Blue” AND Hair Colour = “Brown”

  • Town = “Johnstone” AND Primary = “Thorn”

  • Currency = “Euro” AND Population > 20 million

  • Cost < £1 AND Type = “drink”

  • Height > 2m AND Right handed = “Yes”

  • Resort = “Corfu” AND Cost < £400



SORTING a database





SUMMARY




Do'stlaringiz bilan baham:


Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2017
ma'muriyatiga murojaat qiling