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 |
|
miraskariali
Starting Member
1 Post |
 Posted - 2005-11-04 : 10:15:45
|
| Hi, 1Q How to get the last record of a table in SQL SERVER 2000.2Q How to get the 2/3/4 maximum salary with the same query by just changing the number. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-11-04 : 10:18:23
|
| A1: The order of data in a database has no menaing. You need to supply an ORDERSELECT TOP 1 * FROM myTable99 ORDER BY <something> DESCA2: Probably the homework question is looking for dynamic SQLBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
how to get last record of a table