select rows from 5 to 15 without id coloumn

Discussion in 'Databases' started by sscheral, Jul 24, 2008.

0
  1. #1
    select rows from 5 to 15 without id coloumn

    First take top 15 records and minus top 5 records.

    select top 10 * from Emp where eno not in(select top 5 eno from Emp)


    :)
     
    sscheral, Jul 24, 2008 IP