Search Results

Search found 49727 results on 1990 pages for 'multiple select query'.

Page 233/1990 | < Previous Page | 229 230 231 232 233 234 235 236 237 238 239 240  | Next Page >

• How to select the record contains MAX(some_field) within GROUP(group by)

  - by lovespring

  SELECT MAX(some_field) FROM table_A GROUP BY another_field. this only get the max value of the 'some_field', I wanna get the whole record which contains the MAX(some_field). thanks.

  Read the article

• Generate several sql insert from an sql select sentence

  - by blgnklc

  How can I generate some insert sql sentences using a specific select query. Are there any tool from Ms Sql Server 2008? or else?

  Read the article

• Stored Proc : Use Return or Select at end?

  - by Mike

  If I'm creating a C# wrapper for a stored proc, and that sp only returns/selects (not sure) 1 value, should I use return or select at the end of that sp? This is for t-sql.

  Read the article

• exclude joined rows from a select

  - by Vaccano

  I have two tables. One has rows with values A-Z and the other has D-G. How do I make a select statement to return only the values A-C, H-Z? (This is, of course a dumbed down version of my real tables and problem.)

  Read the article

• Style Option Elements in Select List (Add Padding and/or Margins)

  - by Alex

  Is it possible to style the option elements of a select list/dropdown beyond background and font? I'm specifically looking to add some padding/margins so the list isn't as cramped.

  Read the article

• How to control the font size of html select boxes on iPhone

  - by Zorzella

  Regular HTML select boxes (such as, e.g. found here), while being "chosen" are presented by the iPhone on a native widget that seems to totally ignore regular html font sizes and whatnot. It does some ellipsing when it goes too long, but the font is way too big for a list I want to present -- even on landscape, only about 35 characters can fit. Is there any way to tell the iPhone to use a smaller font there?

  Read the article

• Select a particular column using awk or cut or perl

  - by javed abbas

  Have a requirement to select the 7th column. eg: cat filename | awk '{print $7}' The issue is that the data in the 4th column has multiple values with blank in between. example - The last line in the below output: user \Adminis FL_vol Design 0 - 1 - group 0 FL_vol Design 19324481 - 3014 - user \MAK FL_vol Design 16875161 - 2618 - tree 826 FL_vol Out Global Doc Mark 16875162 - 9618 - /vol/FL_vol/Out Global Doc Mark

  Read the article

• Selecting select fields in jQuery 1.4 not working

  - by Vnuk

  This works in jQuery 1.3.2, but not in 1.4 $("#container").children().map(function() { var child = $(this); if (child.is(":select")) { //do something with child } }); What is the right way to do this in jQuery 1.4?

  Read the article

• Error in computed Field of select Query

  - by Shehzad Bilal

  This Query is giving me an error of #1054 - Unknown column 'totalamount' in 'where clause' SELECT (amount1 + amount2) as totalamount FROM `Donation` WHERE totalamount > 1000 I know i can resolve this error by using group by clause and replace my where condition with having clause. But is there any other solution beside using having clause. If group by is the only solution then I want to know why I have to use group by clause even I havent use any aggregate function thanks.

  Read the article

• Select CSS based on multiple classes

  - by Stacey

  I have a style rule I want to apply to a tag when it has TWO styles. Is there any way to perform this without javascript? In other words.. <li class='left ui-class-selector'> I want to select only if the li has both 'left' and 'ui-class-selector' classes applied.

  Read the article

• How to select only hidden folder from String[]?

  - by Amit Kr. Ghosh

  I want to know how to get only hidden folder from String[]. Actually I have one string array and there show some files. There have normal and hidden files also but I want to try select only hidden folder from this array. So anyone can help me?

  Read the article

• select value of td and download content of selected tds

  - by user1272145

  I have this table <table class="results" id="summary_results"> <tr> <td>select all</td> <td>name</td> <td>id</td> <td>address</td> <td>url</td> </tr> <tr> <td> <input type="checkbox"> </td> <td>john doe</td> <td>1</td> <td>33.85 some address</td> <td>http://www.domain.com</td> </tr> <tr> <td> <input type="checkbox"> </td> <td>jane doe</td> <td>2</td> <td>34.85 some address</td> <td>http://www.domain2.com</td> </tr> <tr> <td> <input type="checkbox"> </td> <td>sam</td> <td>3</td> <td>33.86 some address</td> <td>http://www.domain3.com</td> </tr> </table> I would like to select all the rows then download the content of the urls knowing that each url is linked to the id. for example the first url will be www.domain.com?id=1&report=report

  Read the article

• Select-all checkboxes for a

  - by Horace Ho

  In a form_tag, there is a list of 10 to 15 checkboxes: <%= check_box_tag 'vehicles[]', car.id %> How can I select-all (put a tick in every single) checkboxes by RJS? Thanks

  Read the article

• Generate Numbers and Select in memory

  - by Jasl

  I want to do the following dynamically Generate numbers from 1 to 100 and then select 25 random numbers from it and display it in a console. Any easy way to do so?

  Read the article

• Sql Select Query Question. Merge Rows

  - by Jono

  I have a single MYSQL Question and need help ASAP. Database: Email | Name | Tag [email protected] |Test Person | TagOne [email protected] |Test Person | Tag Two Need an SQL query that will return Email | Name | Tag [email protected] |Test Person | TagOne, Tag Two Any help?

  Read the article

• XPath select tags by id not descendants of

  - by Stefano

  I have the following code and I have to select all the nodes with id="text" but not the nodes that already have a parent with id="text": test00 test01 test02 * test03 * so in this example the query have to return only the two fo:block with content test00 and test03. Thank you.

  Read the article

• Powershell select-object skip multiple lines?

  - by icnivad

  Can i skip multiple lines with the -skip option? gc d:\testfile.txt | select -skip 3 works but what to do if i want to delet line 3-7 ??

  Read the article

• SQL 2008 HierarchyID - Select X descendants down

  - by NTulip

  How can I query a table which has a column of data type HIERARCHYID and get a list of descendants X levels deep under an employee? Here is the current structure: CREATE TABLE [dbo].[Employees]( [NodeId] [hierarchyid] NOT NULL, [EmployeeId] [int] IDENTITY(1,1) NOT NULL, [FirstName] [varchar](120) NULL, [MiddleInitial] [varchar](1) NULL, [LastName] [varchar](120) NULL, [DepartmentId] [int] NULL, [Title] [varchar](120) NULL, [PhoneNumber] [varchar](20) NULL, [IM] [varchar](120) NULL, [Photo] [varbinary](max) NULL, [Bio] [varchar](400) NULL, [Active] [bit] NULL, [ManagerId] [int] NULL )

  Read the article

• How to select an element that has focus on it with jQuery

  - by jQuery Lover

  How can you select an element that has current focus? There is no :focus filter in jQuery, that is why we can use something like this: $('input:focus').someFunction();

  Read the article

• Dynamic select clause in SQL Server from XML

  - by Rohit

  I have to query a view and include only those columns which are defined in the XML which comes as a parameter to my SP. Can i include that XML in select clause and extract all columns defined in that XML. Please tell a way to do this.

  Read the article

• PHP MySQL Select multiple tables

  - by Jordan Pagaduan

  Is it posibble to select 3 tables at a time in 1 database? Table 1: employee -- employee_id -- first_name -- last_name -- middle_name -- birthdate -- address -- gender -- image -- salary Table 2: logs -- log_id -- full_name -- employee_id -- date -- time -- status Table 2: logout -- log_id -- full_name -- employee_id -- date -- time -- status I wanted to get the value of employee table where $id of selected. Then the $id also get the value of log.time, log.date, logout.time, and logout.date. I already try using UNION but nothing happens.

  Read the article

• take only one record of select

  - by jack.cap.rooney

  I need to fetch only first record (because I need last date) of resultset, at the moment I have this resultset from this sql tring: SELECT BCACC,FLDAT FROM ANAGEFLF ORDER BY FLDAT DESC and I see this record: A.M.T. AUTOTRASPORTI SRL 20080220 A.M.T. AUTOTRASPORTI SRL 20080123 A.M.T. AUTOTRASPORTI SRL 20070731 APOFRUIT ITALIA 20080414 APOFRUIT ITALIA 20080205 APOFRUIT ITALIA 20071210 APOFRUIT ITALIA 20070917 APOFRUIT ITALIA 20070907 now I need to take only one record (first) for every BCACC, I would take this resultset: A.M.T. AUTOTRASPORTI SRL 20080220 APOFRUIT ITALIA 20080414 I've just try group it for BCACC but I receive an sql error, I'm workin on DB2 ibmI

  Read the article

• How to select the last 2-element group by a topic_id in MySQL

  - by Luca Romagnoli

  Hi i have to select the 2 lastest element for every topic ex: table: msg id | topic_id ----------- 1 | 1 2 | 1 3 | 1 4 | 1 5 | 2 6 | 2 7 | 2 8 | 3 9 | 3 10 | 3 i want obtain these rows: 3 1 4 1 6 2 7 2 9 3 10 3 How can i do? thanks

  Read the article

• How to Keep the selected value of the select box after Form POST or GET

  - by Rajasekar

  Im trying to implement the search feature in my website. when the search keyword is entered in the textbox, and the category combo is selected, the form will be Posted and the result will be shown on the same page. what i want is to keep the selected category of the combo by default in the form after posted For eg., If i select the category 'Automobiles' in the combo and click search, after form submit, the combo should show the automobiles as default selected option. Please help me. Any help will be appreciated

  Read the article

• using json object data in jquery select

  - by Ratna

  {"names": [ {"patientName": "Ratna"}, {"patientName": "raju" }, {"patientName": "krishna"}, {"patientName": "kishore"}, {"patientName": "Kishore1"}, {"patientName": "mahesh"} ]} this is the JSON object i'm getting from Ajax call so now i want to add all patientName values to select box through jquery can any one tell me how to accomplish this ?? here i'm using $.ajax() function for ajax call thanks in advance

  Read the article

< Previous Page | 229 230 231 232 233 234 235 236 237 238 239 240  | Next Page >