sql - postgresql offset specific column -

-

how select after articleid specific offset start 

e.g start 28 28, 27, 26  offset = 28; limit = 3;  var query = 'select * "article" order "publishdate" desc limit $2 offset $1';  articleid | publishdate  25 | "2015-08-19 15:33:37" 26 | "2015-08-19 17:05:42" 27 | "2015-08-19 17:06:05" 28 | "2015-08-19 17:06:22" 29 | "2015-07-19 17:06:46" 30 | "2015-08-19 17:08:11"

since value of articleid can in where clause try this

select *  article  articleid >= 28 , articleid <= 28 + 3

or if articleid not consecutive

select *  article  articleid >= 28  order articleid limit 3

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

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -

-
my situation follows. let there header file classdeclarations.h , have following classes declared: class classa; class classb; class classa { public: classa(int x); classa(double y); int returninteger(void) { return m_x; } double returndouble(void) { return m_y; } private: int m_x; double m_y; } class classb { public: classb(int x); int returninteger(void) { return m_x; } private: int m_x; classa m_instancea_1; } let there *.cpp file called classdefns.cpp , define methods of classes declared in classdeclarations.h : #include classdeclarations.h classa::classa(int x) : m_x(x) { } classa::classa(double y) : m_y(y) { } classb::classb(int x) : m_x(x) { // line build error occurs m_instancea_1 = classa(0); } note have commented line compiler says there error: error c2512: 'classa' : no appropriate default constructor avai...
Read more

java - How can I send the data from a imput type="file" to the controller? -

-
i have in ftl: <input type="file" id="doc6" name="documente"> in .js: var lx = $("#longx").val(); var ly = $("#laty").val(); var jud = $("#judetpunctlucru").val(); var doc6type = $("#doc6type").val(); var doc6 = $('doc6').val(); validatecoords: function (lx, ly, jud, doc6type, doc6) { var data = { lx: lx, ly: ly, jud: jud, doc6type: doc6type, doc6: doc6 }; var url = contextpath + '/validarecoord'; return getjsondata(url, data); } and in controller: @requestmapping(value = "/validarecoord", method = requestmethod.get, produces = mediatype.application_json_value) @responsebody public map<string, object> getvalidcoord(@requestparam("lx") string lx, @requestparam("ly...
Read more