mysql - SQL: how to select randomly and order by higest -


i have schema this:

create table users      (      id int auto_increment primary key,       name varchar(20),       point int(255)     );  insert users (name, point) values ('jack', 1), ('rick', 5), ('danny', 11), ('anthony', 24), ('barla', 3), ('james', 15), ('melvin', 12), ('orthon', 5), ('kenny', 2), ('smith', 30), ('steven', 27), ('darly', 45), ('peter', 44), ('parker', 66), ('lola', 78), ('jennifer', 94), ('smart', 87), ('jin', 64), ('david', 31), ('jill', 78), ('ken', 48), ('martin', 19), ('adrian', 20), ('oliver', 16), ('ben', 100);

and sql is:

select id, name, point users order point desc, rand() limit 5

problem is, query not select 5 row randomly , order them point. idea, how solve it? here sqlfiddle: http://sqlfiddle.com/#!2/18f15/1

select id,name,point (select id, name, point users order rand()   limit 5) abc order point desc;

sqlfiddle


Comments

Post a Comment

Popular posts from this blog

java - Cast from Object to List<String>: CastClassException -

i'm using touchdb ektorp in android app access couchdb the json document i'm accessing has array of categories: categories: ['cat1', 'cat2'] in view query i'm trying access array classcastexception when trying convert result object list: public void map(map<string, object> document, tdviewmapemitblock emitter) { object dateadded = document.get("dateadded"); object expirydate = document.get("expirydate"); boolean expired = false; if(expirydate!=null){ expired = comparedate.isitemexpired(expirydate); } list<string> test = (list<string>)document.get("categories"); the .get() method works fine single json fields. ideas? document declared map<string, object> so when .get() - return object. there's no direct mapping (list<string>) exception saying need cast object rather list. you ch...
Read more

How to set a border for android Imageview in Longpress? -

in android application want set border imageview when long pressed. want remove same(border) when user releases view. please anyone, me in this? @override public boolean ontouchevent(motionevent event) { switch (event.getaction()) { case motionevent.action_down: { mtouchdownx = (int) event.getx(); mtouchdowny = (int) event.gety(); break; } case motionevent.action_move: { int x = (int) event.getx(); int y = (int) event.gety(); if (mdraggeditem >= 0) { setdraggeditemposition(x, y); int index = getindexfromcoordinates(x, y); if (index == mdraggeditem || index < 0) break; if (index < mdraggeditem) { (int = index; < mdraggeditem; i++) { moveviewtoposition(i, i+1); } (int = mdraggeditem-1; >= index; i--) { ...
Read more

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more