Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Oracle SQL Statement
Hi, I'm wondering, how would you get the identifier ( or the primary key) of the recordset you just inserted without doing a SELECT statement that attempts to check it up by its other characteristics (in Oracle 8)? The reason why I ask is because the recordset I just inserted might not... -
Creating and altering table
I'm using .asp files to execute sql statements to modify a MS Access database. I tried some very simple statements only to find that somehow I can't execute them.<br>The statements are as follows:<br><br>strSQL="ALTER TABLE ADD Column_Name smallint DEFAULT 0"<br><br>For some... -
function and sub...
Hi,<br> I've been programming in asp fairly often now and I pretty much get how to run everything. However, I still don't know what's the difference between function and sub except for the fact that subs can't be used where functions are...- SQLReaver
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
-
Using TOP keyword in a SQL statement. (need help)
Thanks for the response. It really helped and I appreciate it. -
Using TOP keyword in a SQL statement. (need help)
Okay, I found out my problem is actually a conflict with group by and order by statements. I'm wondering if any of you could help me with this problem. The code that I now have is (which is wrong):<br><br>SELECT TOP 10 item, COUNT(item) AS cnt<br>FROM Items AS I1<br>WHERE... -
Using TOP keyword in a SQL statement. (need help)
The code I have provided in the previous post is kind of inadequate. I'm wondering what's wrong with this code now:<br><br>SELECT TOP 10 *<br>FROM Items<br>WHERE Date BETWEEN StartDate AND EndDate<br>GROUP BY Item<br>ORDER BY COUNT(*)<br><br>Basically the database contains a lot of... -
Using TOP keyword in a SQL statement. (need help)
I'm wondering, how would you use the TOP keyword to find the records that are top 10 in the number of times they appear in the database? I know it is very easy to find the top 10 simply by looking at one of the field values but how would you do it by ranking them with the function...
