We've got lots of great SQL Server experts to answer whatever question you can come up with. X Not Just a Number. Cross Join. Home Weblogs Forums Search:. If yes, can someone please tell me how? I'd appreciate it.
These are also summarized in a table at the end of this article. You can also select specified number of records from the bottom of a query result. To do this you can use a trick to order the records in descending order as so:. Keep in mind when the results are sorted in descending order, the largest amounts are returned first. Because of this, TOP returns those products with the highest standard cost.