sql retrieving values form table

[questionit]

Hi

If i have 5 values in a table

1- Value1
2- Value2
3- Value3
4- Value4
5- Value5

How can i write a basic SQL statement to show only first 4 values
OR
to show values 3 to 5 ??#

Thanks

[nomad]

Hi

If i have 5 values in a table

1- Value1
2- Value2
3- Value3
4- Value4
5- Value5

How can i write a basic SQL statement to show only first 4 values
OR
to show values 3 to 5 ??#

Thanks

you could use the where clause
Select * from table_bd where value = value1;
or
the between statment
Select * from table_bd where value between value 1 and value 4;
or
the order by statement
Select * from table_bd order by Value limit 4;

nomad