0
With SQL how do you select all the records from a table named Persons where the LastName is alphabetically between and including Hansen and Pettersen?
Wiki User
∙ 11y ago
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
How can you change Hansen into Nilsen in the LastName column in the Persons table?
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
How can you insert Olsen as the LastName in the Persons table?
INSERT INTO Persons (LastName) VALUES ('Olsen')
How do you select all the records from a table named Persons where the value of the column FirstName is Peter?
SELECT * FROM Persons WHERE FirstName='Peter'
Why is a person an example of matter?
All around us is matter, including persons.
Are there glands in a persons arm?
You have glands in several parts of your body including your arm pits
The most honourable persons of the world?
Anyone could be the most honourable person, including you
Who were the closest persons to William Shakespeare in bibliography?
A bibliography is a list of books or other resources used in writing a formal essay or thesis. The books are generally listed alphabetically by author. Which ones are closest to Shakespeare would therefore depend on which other books are in the list. If there are only two other books on the list, one by Aaron Aardvark and one by Zoe Zlotny, they are the two closest to Shakespeare. If there are a lot more, the closest ones will be the ones closest to Shakespeare alphabetically.
What is a persons way of life including beliefs customs food dwellings and clothing?
A person's way of life.
A comic writer and playwright who made fun of famous people including prominent persons in greek culture?
Aristophanes
Is intake of olive oil ok for diabetic person regularly?
Olive oil is good for everyone including diabetic persons
How does electricity help us to survive?
Electricity is used in most medical procedures including emergency surgeries that will save a persons life.
Who was the first to walk on the the moon and what country was heshe from?
Neil Armstrong. All persons that have been to the moon, including Neil Armstrong, were from the US.
