Select Statement in SQL, SQL Tutorial

	Search All Tutorials

SQL

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification
  Java Applet

Questions

Comments

The SELECT statement for SQL

SELECT key word is used to select data from a table.

Syntax:

SELECT column_name(s)

FROM table_name

Example: To select the content of columns named "LName" and "FName", from the database table called "email", use a SELECT .

SELECT Name, Father_Name FROM EMAIL

The database table "email":

Name	Father_Name	Address
Ram	Sonu	delhi-5

Select All Columns: To select all columns from the "email" table, use a * symbol instead of column names.

SELECT * FROM email

Facing Programming Problem? Ask Questions? Browse Latest Questions Question-Answer Guidelines
Add This Tutorial To:
Del.icio.us	Digg	Google	Spurl	Blink	Furl	Simpy	Y! MyWeb

Current Comments

2 comments so far (post your own) View All Comments Latest 10 Comments:

Hi friends pls send the code to write the connection to sqlserver and to display the table.

regards
vikram

Posted by vikram on Wednesday, 08.13.08 @ 13:59pm | #72623

View This Comment Separately

this is the good site iwant emails from you

Posted by piyush on Monday, 10.29.07 @ 16:46pm | #35064

View This Comment Separately

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.

EAI Articles
Java Certification

Browse all Java Tutorials

Java New to Java? Learn Java In A Day Learn Java Quickly Java Tools Beginners Java Tutorial Master Java Tutorial (TOC) Java IO Package Examples Java AWT Package Examples Swing Example Java util Examples Java Programming	JSP Introduction to JSP JSP Architecture Introduction to the JSP tags Features of JSP 2.1 JSP Fundamentals	Struts Introduction to the Apache Struts Struts Architecture Introduction to the Struts Controller Introduction to Struts 2 Struts 2 Features Struts 2 History	Servlets History of Web application Introduction to Web Server What is servlet? Methods of Servlet Advantages of Java Servlets	Hibernate Introduction to Hibernate 3.0 Hibernate Architecture Hibernate Update Query Hibernate Count Query Hibernate Projections	XML XML : An Introduction XML: An Introduction - Brief History XML:Validation Introduction to DTD DTD:Document Type Definition
Ajax What is Ajax? Ajax Code Libraries and Tools Ajax Login Example	JDBC What is JDBC? JDBC Driver and Its Types Features of JDBC 3.0	EJB Introduction to Application Server Features of EJB 3.0 Message Driven Beans	MySQL Introduction to MySQL Installing MySQL on Windows MySQL Configuration	JavaScript What is JavaScript? Statements In JavaScript Functions in JavaScript	JSF Introduction To JSF JSF Releases JSF Features
Maven2 Tutorial An introduction to Maven 2 Maven 2: Features Maven 2 Eclipse Plug-in	JEE5 Tutorial Understanding JEE technologies JEE 5 API Deploying Application	Java Threading Tutorial Overview of Thread Thread Creation Daemon Thread	Photoshop Tutorials How to design a express realization mode How to design a table lamp	Linux Linux Tutorials Linux CDs Linux Distributions Free Linux CDs	Technology GPS WiMAX VoIP WiFi HSDPA Tech. What is?
Technology Revolutions Rich Internet Application Web 2.0 Web 3.0 JavaFX	Eclipse About IDE Creating a Project	Spring Tutorial Introduction to the Spring Framework	Bioinformatics Tutorials History of Bioinformatics	Tools Junit Jmeter DBUnit	SQL SQL: A brief Introduction Create a database

About Us | Advertising On RoseIndia.net | Site Map

Indian Software Development Company | iPhone Development Company in India

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.