Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
How to select all column values from table in sql
2606 Views
Hints 
Select query used to select all the values from table by using * symbol or else can get value of particular column by useing column name.In select query can use different condition with "And","or" and something like "not like","like","distinct",etc..,

In following example, Get all the values of table
Syntax
select * from tableName;
Example
Get all row of the works_on table

select * from Works_on;
Next
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details