Search Results

Search found 26115 results on 1045 pages for 'table alias'.

Page 411/1045 | < Previous Page | 407 408 409 410 411 412 413 414 415 416 417 418  | Next Page >

• How to use local variables in stored procedures?

  - by ram

  if I want to select any id from a table and want to insert it's value in another table as foreign key then how i will do it through stored procedure?

  Read the article

• SQL Server > Query > Column Names

  - by pojomx

  Hi, I'm here again- I have something like this Select A.a, A.b, A.a+A.b as c, (A.a+A.b*2)+A.d as d from Table But i want to know, if it is possible, to make it work with something like this: Select A.a,A.b,A.a+A.b as c, (c*2)+A.d as d from Table Thank you

  Read the article

• Problem with MySQL query

  - by Psyche

  This time my setup looks like this: one table with galleries names (gallery_id, gallery_name) and another table with galleries photos (photo_id, photo_gallery_id, photo_name). What I need is to get all the galleries with one random picture for each gallery. Is it possible to do this with a single query?

  Read the article

• MySQL: How can I select only the last update for each user?

  - by KeyStroke

  Say I have a 'user_log' table with the following field: id user_id status_text timestamp How do I write a query that selects only the last update for all the users in that table? Appreciate your help :)

  Read the article

• Counting the instances of customers

  - by Mikae Combarado

  Say that I have a table with one column named CustomerId. The example of the instance of this table is : CustomerId 14 12 11 204 14 204 I want to write a query that counts the number of occurences of customer IDs. At the end, I would like to have a result like this : CustomerId NumberOfOccurences 14 2 12 1 11 1 204 2 14 1 I cannot think of a way to do this.

  Read the article

• Query on Vertical partitioning in Sybase

  - by Sairam

  hi, Am working with sybase.In that i have a table A of some 2 million records containing some columns which i want to move out and make it as a separate table B. I have some questions in this process... 1. I have decided to use vertical partitioning.Is that ok? 2.Or what other technique can i go about using in this process? Please provide your valuable inputs in this. Thanks.

  Read the article

• Is existed web markup languages with possibility insert sql query?

  - by MercurieVV

  Actually what I want - simple DB with simple User Interface. Like MS Access, but for web and it can be without Dragn n Drop, but described with markup language. For example if I want to create list report, then i need to write something like: <table query="SELECT * from mytable"></table> It needed for simple data applications. In that kind application no programming logic required. Just working with DB. Changing DB data and showing it.

  Read the article

• Query to check the consistency of records

  - by orunner

  I have four tables TableA: id1 id2 id3 value TableB: id1 desc TableC: id2 desc TableD: id3 desc What I need to do is to check if all combinations of id1 id2 id3 from table B C and D exist in the TableA. In other words, table A should contain all possible combinations of id1 id2 and id3 which are stored in the other three tables.

  Read the article

• fetching only new rows from mysql with jquery ajax

  - by testkhan

  i have a table named news with 3 fields i.e (id, news, time) and i have a setInterval after every 3mints to fetch news from google or any news site .... now i want to fetch only new rows inserted after every 5 minutes...with jquery $.ajax()...how can i do that... do i reload the whole table or there is a way to fetch only the new ones...

  Read the article

• [SQL server] How to insert artificial data into a select statement

  - by user149578

  Hi guys: Suppose we got a original query as follows: SELECT A, B, C FROM tblA Now, I need to additional artificial rows like SELECT 'Kyala', B, C FROM tblA when, for example, C = 100 to be inserted into the resultset. How could I achieve it using a single SQL instead of relying on table variable or temp table?

  Read the article

• Fetching Cassandra row keys

  - by knorv

  Assume a Cassandra datastore with 20 rows, with row keys named "r1" .. "r20". Questions: How do I fetch the row keys of the first ten rows (r1 to r10)? How do I fetch the row keys of the next ten rows (r11 to r20)? I'm looking for the Cassandra analogy to: SELECT row_key FROM table LIMIT 0, 10; SELECT row_key FROM table LIMIT 10, 10;

  Read the article

• rollback not working in mysql

  - by Bharanikumar

  i have user table, i have 5 records , i delete two records , then executed the rollback command, rollback command executed successfully. But that deleted two records not recovered , user table engine is innodb...

  Read the article

• How to generate report

  - by user692495

  I have problem in generate report. I use crystal report 8.5 with vb.net 2008,what I want is when I generate report it will appear red value, if the value is more or less than actual value else it will give default value but when I put this code it give me wrong result If {Intake.wheatType} = {Spec.WheatType} AND {Intake.HB43} >={Spec.M_Min} AND{Intake.HB43} >={Spec.M_Max} Then Red Else DefaultAttribute this report is related with two tables, which is table Spec and table Intake. Could anyone help/teach me how to fix this problem

  Read the article

• sql delete from start

  - by Luke

  Is there anyway I can restrict the amount of rows allowed in a table to say 40, and then when 41st is added, the table deletes the first one?

  Read the article

• sql exception handling

  - by christine33990

  CREATE OR REPLACE PROCEDURE p_createLocaltable IS table_already_exist EXCEPTION; PRAGMA EXCEPTION_INIT (table_already_exist, -00955); BEGIN create table local_table as select * from supplied_table where rownum < 1; EXCEPTION when table_already_exist then DBMS_OUTPUT.put_line('Table already exists , does not need to recreate it'); END; can anyone see any problem of the above code?

  Read the article

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL statement. Is there any way to do two LIMITS in one query based on this kind of criteria?

  Read the article

• chaining and getting the value of an input

  - by cf_PhillipSenn

  This code gets the text that's in a certain column of a table row: var keyA = $(a).children('td').eq(column).text().toUpperCase(); Q: How do I rewrite this to get the value of an input tag that's in the table cell? var keyA = $(a).children('td').eq(column).('input').val().toUpperCase();

  Read the article

• New help with SQL Server select statement

  - by gio_333m

  I need help with select statement in SQL Server / T-SQL My table looks like this: Id (int) QuestionId (int) GenreId (int) I want to select random N rows from this table so that maximum number of same GenreId in the result set is less than X for all GenreId-s except one. For that one GenreId, I need row count with that GenreId to be equal to Y.

  Read the article

• PHP MYSQL SIMPLE SEARCH ISSUE

  - by Kunal

  Hi I have a table with the following structure: id int(11), name varchar(250) I have lots of records in the table but when I am trying to find a particluar record which has the following value on the name field: Lorem ipsum d\'olor sit amet The query is simply returning a blank recordset. I am not being able to figure out this weird behaviour, when my query is as simple as follows: SELECT * FROM slot_games WHERE name='Lorem ipsum d\'olor sit amet' Would appreciate your help please! Thanks in advance.

  Read the article

• ms-access: report that displays records only within a certain date

  - by every_answer_gets_a_point

  i have a very simple report that is generated from just one table. one of the columns in the table is a date. i need to be able to allow the user of the report to enter a range of dates and display data only between those dates. how do i do this?

  Read the article

• NHibernate find

  - by Cory

  I have a 'Customer' table with 'FirstName' and 'LastName' columns. I have to execute a search on the 'Customer' table after 'FirstName', 'LastName' and 'FirstName + LastName' depending on a TextBox text. What's the besty way/query to implement this using NHibernate or SQL query?

  Read the article

• MySQL: How to do a conditional update?

  - by Tom

  Hi, I'm trying to a create an update statement along the following lines: TABLE car: id | owner_id | type | status An owner can have multiple cars. UPDATE car c SET c.type = 1 WHERE c.owner_id IN ($ids) AND c.status = [1 IF IT EXISTS, ELSE 0] $ids is reasonably small (under 50 values). It seems simple but I can't seem to get my head around it because I can't use a SELECT subquery with an UPDATE to the same table. Anyone? Thanks

  Read the article

• How do I check to see if a column is in an xsd?

  - by Timmy

  Is there a simple way to see if the xsd code generating C# code has a particular column? Or if you can reference a variable column? table.getColumn("column") instead of table.column?

  Read the article

• sql - Update Trigger to populate a ModifyDate field

  - by hamlin11

  I'm looking for an example of a good update trigger to update the ModifyDate field of a table. It would be nice to handle the case where an update command updated more than one record in the table. Is there a good template or tutorial for this? Thanks

  Read the article

• SQL query help - finding rows with no relationships

  - by DD

  Consider a DB with a Client table and a Book table: Client: person_id Book: book_id Client_Books: person_id,book_id How would you find all the Person ids which have no books? (without doing an outer join and looking for nulls)

  Read the article

< Previous Page | 407 408 409 410 411 412 413 414 415 416 417 418  | Next Page >