Search Results

Search found 28469 results on 1139 pages for 'select statement'.

Page 153/1139 | < Previous Page | 149 150 151 152 153 154 155 156 157 158 159 160  | Next Page >

• How do I select the first row per group in an SQL Query?

  - by mafutrct

  I've got this SQL query: SELECT Foo, Bar, SUM(Values) AS Sum FROM SomeTable GROUP BY Foo, Bar ORDER BY Foo DESC, Sum DESC This results in an output similar to this: 47 1 100 47 0 10 47 2 10 46 0 100 46 1 10 46 2 10 44 0 2 I'd like to have only the first row per Foo and ignore the rest. 47 1 100 46 0 100 44 0 2 How do I do that?

  Read the article

• How can I make jQuery select an element in the style of CSS?

  - by ben

  <div id="id" class="div-style"><img id="1" class="img-style"></div> I would like to use the id attribute as a way for jQuery to select the element, and the class attribute for CSS to style it. My guess for jQuery selector ran thusly: $("#id .div-class") and $("#id .img-class") This returns the error "Selector expected"

  Read the article

• While using the latest CKeditor (v.3.1), does anyone encounter a stray select box on the page where

  - by Mallika Iyer

  Hello, I'm using the CKEditor 3.1, and find that whereever there is a box on the page, the ckeditor causes a new empty select box to appear next to it (although it has not been applied to that specific element.) This seems to be a known issue : http://dev.fckeditor.net/ticket/4528 Has anyone been able to get around that? Is there any other good fckeditors you can suggest? Thanks!

  Read the article

• UITabBarController is possible to select the tab via code?

  - by ronny

  is it UITabBarController possible to select the tab in code?like UINavigationController we can use popViewController pop back to rootViewController instead of press the back button, so how can this implement in tabbarcontroller?

  Read the article

• in sqlite3, can a select succeed within a transaction of insert?

  - by quantity

  I begin a transaction, which is to insert several records into a table. Can I select the latest inserted record out of the database before the transaction commit?

  Read the article

• How to do a "Select count..." with symfony and propel ??

  - by bahamut100

  Hi, I'm trying to do a very simple sql query like this, to a propel Criteria : SELECT count(id_user) FROM myTable WHERE id_page = 5 I did'nt found informations on the documentation. Have you an idea ??

  Read the article

• How to select a limited amount of rows for each foreign key?

  - by Keyne

  Hi, I have this table: id feed_id ... Let's say that I have 500 rows and I want to select 3 entries for each feed_id? And 50 as total limit. How to write this SQL?

  Read the article

• How can I make a web-based "table" select like a spreadsheet? (rectangular area vs row-wrap selecti

  - by Dax

  I want to make a table that displays on a webpage, but one requirement is to make it easy to copy and paste into a spreadsheet. Normal HTML tables selection behavior is obviously different from how a spreadsheet like Excel selects -- when you select multiple rows it wraps around instead of selecting a rectangular area. Is there any way to make HTML table behave like a spreadsheet in this regard, or is the only way to resort to a Flash table or something similar?

  Read the article

• How to select the IMG tag based on the attribute?

  - by Tejas

  <IMG height="160" alt="Web Content Image" src="../image/journal/article?img_id=16505&t=1273484793531" width="240" pngSet /> I have the this code for the image , and I want to select the image based on the attribute "pngSet" I am trying this , but not working. $("img[pngSet='']").css('border' ,'1px solid red');

  Read the article

• How do I randomly select from a list in Python?

  - by Liam Block

  Basically, I've got a homework task of programming a text based battle simulator in Python. Obviously I've gone with pokémon... I would like the enemy to be randomly selected, however I don't know how to randomly select from a list... foo = ['a', 'b', 'c', 'd', 'e'] from random import choice print choice(foo) This is what I've been told to try but I've got no modules or anything imported... How can I make this work, appreciated.

  Read the article

• min-width not working even using hacks in ie7? (applied to a select)

  - by reg3n

  Hi, i'm trying to get min-width to work on ie7, funny thing is it works correctly on ie6 using this script http://code.google.com/p/ie7-js/ but it doesn't work on ie7 even with the ie8 or ie9 scripts from the same site, any ideas on how to make this property work on a SELECT input? thanks in advance.

  Read the article

• How can I select records from two different tables in one MySQL query?

  - by Fernando

  I have first names stored in one table and last names stored in another. I know this is silly but I am trying out different things as I'm just starting with MySQL. Anyway is it possible to select the first name from one table and the last name from another in one query? And put the result inside a PHP variable?

  Read the article

• can we get the multiple values from a select tag through Ajax script in controller in asp.net MVC?

  - by SAHIL SINGLA

  can we get the multiple values from a select tag through Ajax script in controller in asp.net MVC? I Have tried for Single Value that I have done by .val Function.. But not for Multiple Values Any suggestion Please Help

  Read the article

• How to select rows which start with digit in PostgreSQL?

  - by noxvile

  Need to get rows starting with digit e.g. '1test', '32 test'. I tried SELECT * FROM table WHERE name LIKE '[0-9]%' as I used to do in MSSQL but it wasn't successful.

  Read the article

• JPA Is there a way to do something like SELECT <field>, count(*) FROM <table> GROUP BY <field>

  - by javydreamercsw

  I've been looking in the web for examples on the aggregates like count but it seems all of them are using the aggregate alone. SELECT field, count(*) FROM table GROUP BY field Should have something like: field.value1, x1 field.value2, x2 .... I'm looking for a pure JPA answer for this one. If not I guess I can then do further queries just for the count part but that seems unefficient. Any ideas?

  Read the article

• java script to alert the mutile option selected ..in<select> HTMl tag. and tag .is not inside <form

  - by dpaksp

  java script to alert the mutile option selected ..in<select> HTMl tag. and tag .is not inside <form>tag body how will do it .... thank you

  Read the article

• How do I select the last child of a div with only a certain name using only CSS?

  - by Jared

  Hello, I have been using the following CSS to apply an effect at the bottom of elements in a menu: .leftMenuProductWrapper div:last-child{margin-bottom:20px;} This works fine initially, however after adding more elements in the menu, I realized it was a problem. I really only want to select the last div with .leftMenuProductButton within .leftMenuProductWrapper Anyway to do this without using Jquery, just pure CSS?

  Read the article

• How do I select a camera with imageKit pictureTaker?

  - by Fran

  I would like to use imageKit pictureTaker to take a picture using a digital SLR camera. Buy I can only get pictureTaker to select the iSight.

  Read the article

• Can any body help me for the syntax of select query??

  - by Azka

  i`m doing string sql = "select * from publisher where title like "'"+tbproperty.text+"; but it`s not working! regards..

  Read the article

• SQL select from data in query where this data is not already in the database?

  - by Michael

  I want to check my database for records that I already have recorded before making a webservice call. Here is what I imagine the query to look like, I just can't seem to figure out the syntax. SELECT FROM (1,2,3,4) WHERE id NOT IN table.id Is there a way to do this? What is a query like this called?

  Read the article

• How to get the exact Oracle Error message on a select without the text and store in variable

  - by Paul

  my ($ret) = $l_dbh->selectrow_array("select dummy from " . $l_dbh->quote_identifier($dblink, 'SYSIBM', "SYSDUMMY1") ); $ret; };

  Read the article

• Is there a way to select only integers of a field in mysql?

  - by Lye

  I want to search for numbers, but some of them have - characters or spaces inbetween them, is there a way to do like a select numbersonly(phone) from table ? Thanks.

  Read the article

• How to select data with a certain minimum total?

  - by Dharmendra

  I have one table bbc(country, region, area, population, gdp). I want to select the regions with a total population of at least 100 million. How can I do it with SQL?

  Read the article

• jQuery Selectable only select 1 and get a value?

  - by jphenow

  This might seem like an odd request but I'd like to use jQuery's Selectable tool to only select one item at a time and I'd like it to show me a value I'll have within each tag. At the very least I want the contents of that selection. Has anyone tried to do this? For some reason these little things seem to not be all that easily findable in their API for it.

  Read the article

• How do I select a random record efficiently in MySQL?

  - by user198729

  mysql> EXPLAIN SELECT * FROM urls ORDER BY RAND() LIMIT 1; +----+-------------+-------+------+---------------+------+---------+------+-------+---------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+------+---------------+------+---------+------+-------+---------------------------------+ | 1 | SIMPLE | urls | ALL | NULL | NULL | NULL | NULL | 62228 | Using temporary; Using filesort | +----+-------------+-------+------+---------------+------+---------+------+-------+---------------------------------+ The above doesn't qualify as efficient,how should I do it properly?

  Read the article

< Previous Page | 149 150 151 152 153 154 155 156 157 158 159 160  | Next Page >