C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !



Posted By: Chaitra R       Member Level: Gold       Posted Date: 05 Mar 2008       Category: SQL Server

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

Select Answer:

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'




      
Your Test Score: 0 / 0



Next Question: With SQL, how do you select all the columns from a table named "Persons"?
Previous Question: 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"?
Related Questions:
  • Triggers can be beneficial when used


  • Which of the following commands is used to change the structure of table?


  • SQL stands for


  • Can contain a single SELECT statement function?


  • Which one of the following statements returns the latest Service Pack installed on SQL Server?


    		•

    Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers   BizTalk Adaptors    Web Design

    Contact Us    Privacy Policy    Terms Of Use