mysql - How to get 2nd highest salary from db -

-

to find highest salary db use max in query.

how 2nd highest salary db. can 1 suggest sq query

this should help:

select max(salary)  mytable salary < (    select max(salary) mytable )

Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

python - ValueError: could not convert string to float -

-
i have text file contains data. data follows join2_train = sc.textfile('join2_train.csv',4) join2_train.take(3) [u'21.9059,ta-00002,s-0066,7/7/2013,0,0,yes,1,sp-0019,6.35,0.71,137,8,19.05,n,n,n,n,ef-008,ef-008,0,0,0', u'12.3412,ta-00002,s-0066,7/7/2013,0,0,yes,2,sp-0019,6.35,0.71,137,8,19.05,n,n,n,n,ef-008,ef-008,0,0,0', u'6.60183,ta-00002,s-0066,7/7/2013,0,0,yes,5,sp-0019,6.35,0.71,137,8,19.05,n,n,n,n,ef-008,ef-008,0,0,0'] now trying parse string function splits each of lines of text , convert labeledpoint. have included line converting string elements float the function follows from pyspark.mllib.regression import labeledpoint import numpy np def parsepoint(line): """converts comma separated unicode string `labeledpoint`. args: line (unicode): comma separated unicode string first element label , remaining elements features. returns: labeledpoint: line converted `labe...
Read more

php - Laravel Get all child node count with condition -

-
i using laravel5.1 in application. in have 1 table name users , schema of user table follow. id name parane_id node 1 abc 0 2 xyz 1 l 3 dfs 1 r 4 gjk 2 l 5 dsg 3 l 6 faf 4 r 7 kes 2 r i want count of user left side on user 1 (i.e 2,4,6,7) count 4. same if want right side of 2 return 7 count 1. how can possible using laravel eloquent . any appreciated. you want count tree nodes on condition in case left children of node. define children user . create function traverse children tree , counting. class user extends model { public function children() { return $this->hasmany('app\user', 'parent_id'); } public function countchildren($node = null) { $query = $this-...
Read more