What if we want to select a range of names thats doesn't start from the beginning? i.e Like from 3rd to 7 th

Question

SQL

Answer 1

SELECT * FROM table
LIMIT 2,4

2 is stand for start index and 4 is stand for indent( number of recordes after start index)

( sql is zero base)

Answer 2

thanks... another one question
which is better sql database or oracle database?

Answer 3

it's related to your business if you are linux user you have to use oracle or mysql if you are windows user. you can use access or mssql or oracle

if your data is not more than 2 or 3 record perday and your app single user you implement with sql
if your database is great than that .... until 1 million record ber day use mssql

if you want implement for huge data or your app is releated to data mining or bi use oracle ...
cost of using oracle is very more than mssql but if you implement your server. and configuring oracle dbms correctly it's hundred time faster that mssql else it's worse than txt file.....

it is related to you knowledge and your money