Re: Getting next records
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Mon, 12 Sep 2005 21:06:19 -0500
>>Assuming you where using the Employees table from the Northwind sample database
>>Select Top 50 *
>>where [EmployeeId] >
>>(Select Max(employeeID) from (Select top 50 [EmployeeId] from employees))
>>Brian Bushay (TeamB)
>In fact, table key has 2 fields. Using your example, we would have EmployeeID and DeptID. I tried to adapt your example to include the second field but I really was not able to do it.
>Please, can you help me again rewriting your command with a second field in the key?
Select Top 50 *
where [key2]+[key2] >
Select (Max([key1]+[key2]) from (Select top 50 [key1],[key2] from employees))
Brian Bushay (TeamB)