Chaitanya Lakshmi
  • About Me
  • Job Duties
  • Knowledge Blog
  • Applications
  • Contact Us
    • Linked In
    • Facebook
  • About Me
  • Job Duties
  • Knowledge Blog
  • Applications
  • Contact Us
    • Linked In
    • Facebook

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” starts with an “a”?

2/27/2012

0 Comments

 
  • SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
  • SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
  • SELECT * FROM Persons WHERE FirstName=’%a%’
  • SELECT * FROM Persons WHERE FirstName=’a’
  • I don’t know
Answer:
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
0 Comments



Leave a Reply.

    Author

    Write something about yourself. No need to be fancy, just an overview.

    Archives

    February 2012

    Categories

    All
    General
    Krds
    Phponweb

    RSS Feed

Powered by Create your own unique website with customizable templates.