Total members 11889 |It is currently Fri Mar 29, 2024 12:56 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





what is the query to retrieve to student data ( ex: name,rollno,total) based on least 5 total marks...??

any body plz help!!




Author:
Beginner
User avatar Posts: 54
Have thanks: 0 time

you mean like this
Code:
select name,rollno,total from student where total>5


_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

no bro..
i want to retrieve 5 students data who secured least marks of total...


Author:
Beginner
User avatar Posts: 54
Have thanks: 0 time

you want to order them by date , you want to get the most recent students those get a specific grade of total X ?

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

no bro..
take a example table below...
sname marks
a 50
b 42
c 78
d 36
e 88
f 38
g 45
h 92

here i want to retrieve the data (sname,marks) of 5 students who secured less marks ie i want to display the folloeing data

sname marks
a 50
b 42
d 36
f 38
g 45


Author:
Beginner
User avatar Posts: 54
Have thanks: 0 time

ah ok , you can use limit and order ascending like this


Code:
select name,rollno,total from student order by total asc limit 0,5


_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

thank u very much bro!!:)


Author:
Beginner
User avatar Posts: 54
Have thanks: 0 time
Post new topic Reply to topic  [ 7 posts ] 

  Related Posts  to : what is the query to retrieve to student data based on least
 How to upload and retrieve image in jsp please send me code     -  
 Cookie based login in php     -  
 prapose me a web based mini project     -  
 Home Based Research Jobs.     -  
 Takes a string apart based on a delimiter     -  
 Run different function based on the selected Tab JTabbedPane     -  
 Circle drawing using Polar based algorithm with C++     -  
 Simple Text-Based RPG Java Project Help!     -  
 Hi, i sm sn B-Tech student i need ur help. u can help me     -  
 Draw a blank Canvas based on the size and color set     -  









Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com