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 |
|
Nowy
Yak Posting Veteran
57 Posts |
 Posted - 2007-05-30 : 05:17:30
|
| How to get 3rd record? In MySQL I used the LIMIT function but this doesn't work in MS2000 |
|
|
pbguy
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-05-30 : 05:24:42
|
| based on what..post some sample data--------------------------------------------------S.Ahamed |
 |
|
|
Nowy
Yak Posting Veteran
57 Posts |
Posted - 2007-05-30 : 05:31:08
|
| in MySQL I used the following querySELECT RecordID FROM tblSupport LIMIT 2,1how can I do the same in MS2000? |
|
|
|
pbguy
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-05-30 : 05:37:16
|
| U have to use TOPSelect Top 3 * from <ur table name>--------------------------------------------------S.Ahamed |
|
|
|
Nowy
Yak Posting Veteran
57 Posts |
Posted - 2007-05-30 : 05:44:30
|
| ok but it gives 3 records, I only want the 3rd record |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-30 : 06:21:39
|
Define 3rd record  Select min(col) as col from ( Select top 3 col from table order by col DESC ) T MadhivananFailing to plan is Planning to fail |
|
|
|
Nowy
Yak Posting Veteran
57 Posts |
Posted - 2007-05-30 : 07:06:51
|
| thnx |
|
|
|
|
|
|
Get 3rd record