Hi,

I want to get all the records from the table.

What is the query to get all the records from the database?

select statement without any condition can be .
Actually ,Can you tell the purpose of doing ? and What do you mean by all records from database? 

Hi Noor,

To get all the records from table please use the following query:

Select * from Table1

Where Table1 is the name of table.

Hi Noor,

You can use select statement to get all records from the table.

Select * from Table

Please read below SQL tutorial link to understand the SQL queries,

http://www.w3schools.com/sql/default.asp