Search Results

Search found 31421 results on 1257 pages for 'entity sql'.

Page 756/1257 | < Previous Page | 752 753 754 755 756 757 758 759 760 761 762 763  | Next Page >

• Concatenate and group multiple rows in Oracle

  - by user1693347

  Suppose I have a table like this: NAME GROUP name1 groupA name2 groupB name5 groupC name4 groupA name3 groupC I'd like to have a result like this: GROUP NAMES groupA name1,name4 groupB name2 groupC name3,name5 If there were only one column in the table, I could concatenate the records by doing the following, but with grouping in the context, I really don't have much idea. Any suggestion is welcome, thanks in advance! Concatatenating one column table: SELECT names FROM (SELECT SYS_CONNECT_BY_PATH(names,' ') names, level FROM name_table START WITH names = (SELECT names FROM name_table WHERE rownum = 1) CONNECT BY PRIOR names < names ORDER BY level DESC) WHERE rownum = 1

  Read the article

• Error 49 bad bind variable oracle forms

  - by mysticfalls

  I would like to ask regarding this error... Error 49 at line 5, column 6 bad bind variable 'S_ORD.payment_type' Here is the code: DECLARE N NUMBER; v_credit S_CUSTOMER.credit_rating%type; BEGIN IF :S_ORD.payment_type = 'CREDIT' THEN SELECT credit_rating INTO v_credit FROM S_CUSTOMER WHERE :S_ORD.customer_id = id; IF v_credit NOT IN ('GOOD', 'EXCELLENT') THEN :S_ORD.payment_type:= 'CASH'; n:=SHOW_ALERT('Payment_Type_Alert'); END IF; END IF; END; I'm new to oracle forms so I'm not sure if I have a missing setup or anything. S_ORD table exist and has a column payment_type, which consists of 'CREDIT' and 'CASH' value. Thank you.

  Read the article

• ERROR: there is no parameter $1 when creating view

  - by idlemoments

  When we try to create a view within a funcion we get ERROR: there is no parameter $1. This is the sample code. Begin CREATE VIEW artikelnr AS SELECT datum, 'uitgifte' as "type", CASE WHEN 'test'='test' THEN 0 END as "aantal ontvangen", aantal as "aantal uitgegeven" FROM uitgifteregel JOIN artikel ON artikel.artikelnr = new.artikelnr JOIN uitgifte ON uitgifte.uitgiftenr = uitgifteregel.uitgiftenr UNION SELECT datum, 'ontvangst' as "type", aantal as "aantal ontvangen" , CASE WHEN 'test'='test' THEN 0 END as "aantal uitgegeven" FROM ontvangstregel JOIN artikel ON artikel.artikelnr = new.artikelnr JOIN ontvangst ON ontvangst.ontvangstnr = ontvangstregel.ontvangstnr; Return new; end; When we replace new.artikelnr on line 7 with value 1 it works like it should, but the function needs to work with different artikelnr's. example line 7: JOIN artikel ON artikel.artikelnr = new.artikelnr Please point us in the right direction.

  Read the article

• Can I apply NOLOCK with a database-wide setting?

  - by Beemer

  Is there a way to make WITH(NOLOCK) be applied on any SELECT statement run on a particular database?

  Read the article

• help for a query

  - by stighy

  Hi, i've a problem for a table update. follow table structure: Table1 tableid ... ... productID_1 productID_2 productID_3 Table2 productID Total I've to totalize each product in table2. For example: SELECT COUNT(*) as tot, ProductID_1 FROM Table1 GROUP Table1 then the UPDATE table2 SET total =..??? (how can i do) WHERE productID_1 = .... Hope you can help me. Thank you

  Read the article

• How do you check if a certain index exists in a table?

  - by Lieven Cardoen

  Something like this: SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME ='FK_TreeNodesBinaryAssets_BinaryAssets' and TABLE_NAME = 'TreeNodesBinaryAssets' but for indexes.

  Read the article

• check if a value is NULL or Less than 0 in one TSQL statement

  - by Name.IsNullOrEmpty

  ISNULL(SUM(MyTable.Total), 0) AS Total how can i modify the above statement to also check if Total is less than 0 (zero), such that if Total is NULL or less than 0 (negative), i assign 0 to Total

  Read the article

• How do database servers decide which order to return rows without any "order by" statements?

  - by Chris

  Kind of a whimsical question, always something I've wondered about and I figure knowing why it does what it does might deepen my understanding a bit. Let's say I do "SELECT TOP 10 * FROM TableName". In short timeframes, the same 10 rows come back, so it doesn't seem random. They weren't the first or last created. In my massive sample size of...one table, it isn't returning the min or max auto-incrementing primary key value. I also figure the problem gets more complex when taking joins into account. My database of choice is MSSQL, but I figure this might be an interesting question regardless of the platform.

  Read the article

• Oracle: get list of all tables?

  - by vitule

  How do I query an Oracle database to display the names of all tables in it?

  Read the article

• How to write a query get all infomation from one table to another one

  - by Dave

  I am building access database that will get data from a outside source and place it in a table that is link to the data source. As we all know that you are not allowed to recinfigure that linked table. What I want to do is take that data from that that linked table and make another table that I will be able to add additional new fields and snyc the out that gets put into the linked table. Please Help

  Read the article

• How to do Group By in grails to order bei Count(*)

  - by skurt

  How do I translate: SELECT COUNT(*) AS `count`, `a` FROM `b` GROUP BY `a` ORDER BY `a` into grails or gorm query?

  Read the article

• Count, inner join

  - by Urosh

  I have two tables: DRIVER (Driver_Id,First name,Last name,...) PARTICIPANT IN CAR ACCIDENT (Participant_Id,Driver_Id-foreign key,responsibility-yes or no,...) Now, I need to find out which driver participated in accident where responsibility is 'YES', and how many times. I did this: Select Driver_ID, COUNT (Participant.Driver_ID)as 'Number of accidents' from Participant in car accident where responsibility='YES' group by Driver_ID order by COUNT (Participant.Driver_ID) desc But, I need to add drivers first and last name from the first table(using inner join, I suppose). I don't know how, because it is not contained in either an aggregate function or the GROUP BY clause. Please help :)

  Read the article

• Fill data gaps without UNION

  - by Dave Jarvis

  Problem There are data gaps that need to be filled, possibly using PARTITION BY. Query Statement The select statement reads as follows: SELECT count( r.incident_id ) AS incident_tally, r.severity_cd, r.incident_typ_cd FROM report_vw r GROUP BY r.severity_cd, r.incident_typ_cd ORDER BY r.severity_cd, r.incident_typ_cd Code Tables The severity codes and incident type codes are from: severity_vw incident_type_vw Actual Result Data 36 0 ENVIRONMENT 1 1 DISASTER 27 1 ENVIRONMENT 4 2 SAFETY 1 3 SAFETY Required Result Data 36 0 ENVIRONMENT 0 0 DISASTER 0 0 SAFETY 27 1 ENVIRONMENT 0 1 DISASTER 0 1 SAFETY 0 2 ENVIRONMENT 0 2 DISASTER 4 2 SAFETY 0 3 ENVIRONMENT 0 3 DISASTER 1 3 SAFETY Any ideas how to use PARTITION BY (or JOINs) to fill in the zero counts?

  Read the article

• What is the best practise for relational database tables in mysql?

  - by George

  Hi, I know, there is a lot of info on mysql out there. But I was not really able to find an answer to this specific and actually simple question: Let's say I have two tables: USERS (with many fields, e.g. name, street, email, etc.) and GROUPS (also with many fields) The relation is (I guess?) 1:n, that is ONE user can be a member of MANY groups. What I dis, is create another table, named USERS_GROUPS_REL. This table has only two fields: us_id (unique key of table USERS) and gr_id (unique key of table GROUPS) In PHP I do a query with join. Is this "best practice" or is there a better way? Thankful for any hint!

  Read the article

• delete records from a table based on data from a different table

  - by every_answer_gets_a_point

  table1 has column CITY and COUNTRY. table2 has column CITY. how do i delete from table2 all records that have CITY in common with table1 but also the COUNTRY='Russia' ?? please keep in mind that both tables have about 1 million rows of data

  Read the article

• EXPLAIN and COUNT returning two different values

  - by every_answer_gets_a_point

  i am doing: explain select * from calibration; it says 521332 rows when i do: select count(*) from calibration; i am getting 521961 can someone explain whats going on here?

  Read the article

• Oracle Group By Issue

  - by m_oLogin

  Hello community, I am strugling with what seems an easy problem to tackle (at least for me in MySQL / SqlServer!) I'll simplify the problem. Let's say I have the following table: Table VOTE ID ID_IDEA DATE_VOTE with ID_IDEA FK(IDEA.ID) 1 3 10/10/10 2 0 09/09/10 3 3 08/08/10 4 3 11/11/10 5 0 06/06/10 6 1 05/05/10 I'm trying to find the latest votes given for each individual idea, meaning I want to return only rows with ID 4, 2 and 6. It seems with Oracle that you can't use GROUP BY without using a function like SUM(), AVG, etc. I'm a bit confused about how it's supposed to work. Please advise, Thanks.

  Read the article

• Selecting all tables with no records

  - by sqlgrasshopper5

  I need to display all tables that have zero records. I tried, select * from user_all_tables where (select count(*) from user_all_tables)=0; But it doesn't seem to work. How should I go about redesigning this query? Thanks.

  Read the article

• Check mysql_query results if DELETE query worked?

  - by Camran

  I have a DELETE query which deletes a record from a mysql db. is there any way to make sure if the delete was performed or not? I mean, for a query to FIND stuff you do $res=mysql_query($var); $nr=mysql_num_rows($res); and you get nr of rows returned. Is there any similiar method for deletion of records? Thanks

  Read the article

• Get all entries from one table together with the count of these entries in another table.

  - by Emanuil

  I've got 3 tables: users (id, name, ...) items (id, name, ...) downloads (user_id, item_id, ...) How do I get all users together with the number of downloads they have?

  Read the article

• analyze table, optimize table, how often?

  - by every_answer_gets_a_point

  in mysql i have 3 tables. one is 500,000, another 300,000, and finally around 5,000 they each get maybe 50-500 additional rows daily should i run analyze and optimize table on them? if so then how often?

  Read the article

• php mysql_fetch_array() error

  - by user1877823

  I am getting this error while i am trying to delete a record the query is working but this line remains on the page. i want to echo "Deleted" written in the while should show up but the while loop is not working, i have tried and searched alot nothing helps! mysql_fetch_array() expects parameter 1 to be resource, boolean given in delete.php on line 27 delete.php <html> <body> <form method="post"> Id : <input type="text" name="id"> Name : <input type="text" name="name"> Description : <input type="text" name="des"> <input type="submit" value="delete" name="delete"> </form> <?php include("connect.php"); $id = $_POST['id']; $name = $_POST['name']; $des = $_POST['des']; $result = mysql_query("DELETE FROM fact WHERE id='$id'") or die(mysql_error()); while($row = mysql_fetch_array($result)) { echo "Deleted"; } mysql_close($con); ?> </body> </html> connect.php <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("Dataentry", $con); ?> How should i make the while loop work..

  Read the article

• neww help with MSSQL select statement

  - by gio_333m

  Hello, I need help with select statement in MSSQL. 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. Thanks in advance

  Read the article

• Which of these queries is more efficient?

  - by Brian

  Which of these queries are more efficient? select 1 as newAndClosed from sysibm.sysdummy1 where exists ( select 1 from items where new = 1 ) and not exists ( select 1 from status where open = 1 ) select 1 as newAndClosed from items where new = 1 and not exists ( select 1 from status where open = 1 )

  Read the article

• sql clarification

  - by JPro

  Can anyone please clarify what this query will return ? SELECT TestCase FROM MyTable WHERE Verdict = 'PASS' AND StartTime > DATE_SUB(NOW(), INTERVAL 2 MONTH)

  Read the article

< Previous Page | 752 753 754 755 756 757 758 759 760 761 762 763  | Next Page >