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 Rhinorhino 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)
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...
