Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2001-06-14 : 12:22:13
|
| I want to select records 10 to 20 from the statement below. The 'What's after TOP ?' article has only one variable being selected, but, how does the WHERE clause work when i have four variables ? SELECT Top 10 H.Fund_Man as Institution, H.FMCode, H.Pcent as Shares_Outstanding, C.Reg_Date as Interval_Date FROM Citywatch_Company_Archive C INNER JOIN Citywatch_Holders_Archive H ON C.Epic = H.Epic AND C.Archive_Date = H.Archive_Date WHERE C.Epic = 'aal' -- hard coded for testing please ignore-- what is the WHERE clause syntax that should go here ORDER BY Institution ASC |
|
|
|
|
|
More SELECT TOP ?