•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 375,174 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,203 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 6225 | Replies: 2
 |
•
•
Join Date: Mar 2005
Location: INDIA
Posts: 40
Reputation: 
Rep Power: 4
Solved Threads: 0
Light Poster
I want to get list of top 10 students (based on marks) in class.How can I write SQL query for it?
•
•
Join Date: Apr 2005
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi There
Try The Following
SELECT DISTINCTROW TOP 10 Students.StudentName AS TopTenStudents, Students.StudentGrade
FROM Students
Rgds
Try The Following
SELECT DISTINCTROW TOP 10 Students.StudentName AS TopTenStudents, Students.StudentGrade
FROM Students
Rgds
•
•
Join Date: Oct 2007
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
This sounds similar to something I'm trying to do...
I'm trying to write a query to get my video database to display names and addresses of people who have hired five videos or more....so far I'm displaying everyone who has hired a video - not too sure how to make it realise that I only want the ones who have hired more than five videos!!! I'm stuck
Any ideas are greatly appreciated
I'm trying to write a query to get my video database to display names and addresses of people who have hired five videos or more....so far I'm displaying everyone who has hired a video - not too sure how to make it realise that I only want the ones who have hired more than five videos!!! I'm stuck
Any ideas are greatly appreciated
Last edited by iseedeadpixels : 7 Days Ago at 10:15 pm.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
- MS Access vs. MySQL (MS Access and FileMaker Pro)
- sql query problem with MS Access and C# (C#)
- Not able to save query in access (Techies' Lounge)
- i want to save a query in MS Access Database throug c# coding (C#)
- Cant' figure out where my syntax error is (Access query) (MS Access and FileMaker Pro)
- problems with recordset accessing access (Visual Basic 4 / 5 / 6)
- Access XP Crashes at Query Run (MS Access and FileMaker Pro)
- Create a Desktop Shortcut that Locks a Windows XP-Based Workstation (Windows tips 'n' tweaks)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Turn Off Import Errors
- Next Thread: Querying from a combo box selection
