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 |
|
annas
Starting Member
36 Posts |
 Posted - 2007-10-07 : 11:32:39
|
| Haii..Can anyone help me, im trying to take a data in database at END OF FILE.Does anyone knew what is the query. Im quite lost..Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-10-07 : 11:57:15
|
I don't understand the question. What are you trying to do?
elsasoft.org |
 |
|
|
annas
Starting Member
36 Posts |
Posted - 2007-10-07 : 12:14:24
|
| Haii jezemine,sorry 4 unclear question. What im trying to do is, i want to select a data in table. For Example there are 10 CustID number,so i want to take data at CustID = 10, means at the end of the CustID, if there are 6 CustID, i want to select the end CustID, which is 6. i dun want to use the WHERE statement because it fix to certain Data or Id. So can u help me with this, sorry my english quite bad...Thank U |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2007-10-07 : 12:19:56
|
| SELECT *FROM CustomerWHERE CustID = (SELECT MAX(CustID) FROM Customer)=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
|
|
|
End Of File