sql - limit and offset on joined table -

-

I have 2 tables category and items , let me show it Lift and offset by Categoy ID

Descending sequence with category table: 

  a | B ----- + ----- 1 | Cat 1 2 | Cat 2 3 | Cat 3 4 | Cat 4 5 | Cat 5 6 | Cat6   
 When this SQL code is run  
  SELECT c *, F.Amount, f.Item FROM item_table f LEFT JOIN (SELECT * FROM range c LIMIT 'offset.', 3) ASCF CATIID = CID Order CID DED   
 return me like this  
  A | B Items ----- + ------------- 3 cat 3 | Items, items ... 2 | Cat 2 Items, items ... 1 | Cat 1 | Item, item ...   
 but I should return it to me  
  a | B Item ----- + ------------- 6 | Cat 6 Items, items ... 4 | Cat 4 Items, items ... 5 | Cat 5 | Item, item ...   
 How can I do this?   
 
 
 Add order by section within subquery.  
  SELECT c. *, F.Amount, f.Item item_table f LEFT JOIN (SELECT * FROM range by c ORDER c.id desc LIMIT). $ Offset ', 3) ASCF CATIID = CID Order ccid Ded

Comments

Post a Comment

Popular posts from this blog

python - Writing Greek in matplotlib labels, titles -

-
Image
I'm trying to write some text for labels, shape titles etc. with my plots, but no benefit till now Has not happened . I do not want to print specific characters (I know how to use special characters), I want to write the entire text in Greek (maybe Unicode and text ' ?). , suggesting that I would like to mention that for some reason I can not get matplotlib to cooperate with Tex (using IPython notebook from Anaconda in Ubuntu 14.10) so that there really is an option Will not be the first. I tried loading the Arial font and it loads successfully but again I get square blocks instead of characters. I import matplotlib.font_manager FM PROP = FM Font Properties (fname = '/ usr / share / fonts / truetype / msttcorefonts / Arial.ttf') And then to display the string I u'Î? ? I ?? Î¿Ï ?? ÎμÎ »second ?? μΠ± i ?? I ± i ?? I ?? Used ο किया? ? Î¿Î¼Î¿Î¯Ï ?? I ?? I · I ?? ' . Ariel is considered to be fully presented to Greek and I have used it many times ...
Read more

cmake set_source_files_properties not working properly -

-
I have a project in which. C is a group of files which need to be compiled as C files, but I need it to be compiled as C ++ code. I tried the solution I found, but did not work as expected. Instead of making filename.c only, it is compiled as C ++, it compiles all the files in my project as C ++ code. Without that call, all the files have been compiled as C. I also tried: set_source_files_properties ($ {FILES_SRC} property languages ​​C) set_source_files_properties (filename.c property languages ​​CFX) Where FILES_SRC variable keeps all my source files. I am CMK 2.8.12 and Visual Studio 11 ARM Generator. Any ideas how can I fix this? I finished compiling the library using C compiler and added a C ++ code to a different library For which I created a C interface so it can be told from my C library.
Read more

Pygame memory leak with transform.flip -

-
Today I came across an interesting issue which, by writing a small side scroller, instead of a sprite sheet, I was planning to use because I lacked a good "packer" for making phantom sheets (and honestly with patience and passion as it is only a test project). Anyway, I showed the animation running on the right of 8 PNG (with transparency). I considered it a good idea to prepare the flipped images to run on the left in the consultant, and the frame is not framed when the game is running (Flip actually consumes a lot of CPU like I Was measured). > To get access to the loop, I get the memory leak self.move_l = [# 8 PNG images with transparency to the right] For the self in IMG. Move_l: self.move_r.append (pygame.transform.flip (img, true, false) error traceback: traceback (most recent Call final): The file "D: \ Python 34 \ _Projects \ efg \ efg.py", in line 196, in the & lt; module & gt; main = master program ((1024, 680)) "D: \ Python ...
Read more