what is the query to retrieve to student data based on least

saics

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

any body plz help!!

DrRakha

you mean like this

Code:

select name,rollno,total from student where total>5

saics

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

DrRakha

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

saics

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

DrRakha

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

saics

thank u very much bro!!:)

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 based on least