Advertisement
Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.
SELECT * FROM Persons WHERE LastName > 'Hansen', LastName < 'Pettersen'
SELECT LastName > 'Hansen' AND LastName < 'Pettersen' FROM Persons
SELECT * FROM customers WHERE LastName > 'Hansen' AND LastName > 'Pettersen'
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
Answer: Answer is d
Further Reading:
Useful resources, BETWEEN
![Share on Facebook](https://www.facebook.com/dialog/feed?app_id=498142106921148&link=http://read4learn.com/question/322/what-is-the-correct-sql-syntax-for-selecting-all-the-columns-where-the-lastname-is-alphabetically-between-and-including-hansen-and-pettersen&picture=http://www.read4learn.com/content/images/search-logo.jpg&name=What is the correct SQL syntax for selecting all the columns where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?&description=a)
SELECT * FROM Persons WHERE LastName > 'Hansen', LastName < 'Pettersen' b)
SELECT LastName > 'Hansen' AND LastName < 'Pettersen' FROM Persons c)
SELECT * FROM customers WHERE LastName > 'Hansen' AND LastName > 'Pettersen' d)
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' Answer: Answer is d. Further Reading:
Useful resources, BETWEEN
&redirect_uri=http://read4learn.com/question/322/what-is-the-correct-sql-syntax-for-selecting-all-the-columns-where-the-lastname-is-alphabetically-between-and-including-hansen-and-pettersen&display=popup){kind=logo}
