Solution: SELECT first, last FROM table_name WHERE last LIKE '%ay';
Quotes help make search much faster. Example: "Practice Makes Perfect"
Wednesday, September 4, 2013
SQL Problem: Display the first and last names for everyone whose last name ends in an "ay".
Solution: SELECT first, last FROM table_name WHERE last LIKE '%ay';
Labels:
SQL
Subscribe to:
Post Comments (Atom)
This is an example of scrolling text using Javascript.
Popular Posts
-
#sample solution pyg = 'ay' original = raw_input('Enter a word:') if len(original) > 0 and original.isalpha(): p...
-
A typical compounding problem would be something like: How much is the equivalent Present Value (P) if an investment pays an amount (A...
-
A typical compounding problem would be something like: How much will I get annually (A) starting next year if I invest a present value...
-
<style> p { font-family: sans-serif; font-size:18px;} div#welcome p{ font-family: cursive; font-size: 24px; color: white; b...
-
A typical compounding problem would be something like: What is the present value (P) of a future value (F) if (P) was deposited/lent a...
-
// Sample solution // Write a string rotation method. // It should pass all the tests given below. String.prototype.rotate = function(n...
-
A typical compounding problem would be something like: What is the future value (F) of a present value (P) deposited/lent at an intere...
-
<style> #content p {color: yellow;} p {color: purple;} p {color: green;} </style> <div id="content...
-
#sample solution class Triangle(object): #member variables number_of_sides = 3 #methods def __init__(self, angle1, angle2, angle...
-
#sample solution class Shape(object): """Makes shapes!""" def __init__(self, number_of_sides): self....
No comments:
Post a Comment