• Home
  • Tutorials
  • Interviews
  • Info Seed
  • Forums
  • Projects
  • Links
  • Contact Us
SQL Server
HOW TO START...??
CREATING DATABASE
CREATING TABLE
INSERTION
SELECTION
USING DISTINCT
WHERE CLAUSE
AS IN SQL
OPERATORS
DELETE
UPDATE
LIKE OPERATOR AND WILDCARDS
BETWEEN OPERATORS
IN CLAUSE
ORDER BY
JOINS
UNION
INTERSECT
ALL/ANY
SQL CONSTRAINT
INDEX
DROP
Alter
FUNCTIONS
GROUP BY
HAVING CLAUSE
VIEWS

Selection

  • To view the whole list of the table you have two options
  • First is that you right click on the table and select the ‘open table’ option or
  • You can use a query using ‘Select’ keyword

Syntax

Select * from table_name

Example-6:

+ Whole list is displayed under the Results column when you click on Execute

  • Now if you want to view only one or two particular column(s) from the table Select is used as follow

Syntax

Select column_name1,column_name2....from table_name

Example-7:

 

 

 

previous next
 
Lorem: Lorum | Ipsum | Dolar | Sic Amet | Consectetur | Lorum | Ipsum | Dolar | Sic Amet | Consectetur