📊 SQL Server
Q. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
  • (A) SELECT * FROM Persons WHERE FirstName=’%a%’
  • (B) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
  • (C) SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
  • (D) SELECT * FROM Persons WHERE FirstName=’a’
💬 Discuss
✅ Correct Answer: (B) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

You must be Logged in to update hint/solution

💬 Discussion

📊 Question Analytics

👁️
208
Total Visits
📽️
4 y ago
Published
🎖️
Ram Sharma
Publisher
📈
82%
Success Rate