Databases Forum

I need a query that will find for example in the given table Distinct Col1, with highest Col3 [CODE]A X 1 A Y 2 A X 3 B Y 2 B Z 4[/CODE] So the result should be: [CODE]A X 3 B Z 4[/CODE]

hi... I am beginner for Oracle. Please anyone can tell me how we can assign primary key in to a particular field???????

hello all please help me asap i am retriving data from my sql and i want to some perticular text of result in bold formate for understanding [CODE]select Desdription from tablename[/CODE] normal result: hello all wanted result: [B]hello[/B] all

hello, I am facing a problem with the following code: select year(regdate) as [Year],month(regdate) as [Month], CONVERT(varchar(3),regdate,100)as inmonth, count(*) as incount, cast(sum(amt)as decimal(20,2))as insum, count(case when nbr <>' ' then amt else Null end) as incountpo, SUM(case when nbr <>' ' then (amt)else 0.00 end)as insumpo, --cast( (Insumpo / InSum …

i have create a registration form in asp.net & sql server..It's working good.. i generate ID for user when they click "sign Up" button..(the ID will appear in drop down list at form-ID not saved yet into database).. the problem is when several user register at same time and click …

Greetings, I have table CUSTOMER: [CODE] mysql> describe CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(35) | NO | | NULL | | | STREET | …

how to instal my sql?

hi, i have read around and all i seem to find is one and in the where clause along with an OR or either but i was wondering if it was fine to use 2 or maybe 3 AND in the where clause? most of my where clauses in past …

Is it possible to get system utilization information in pl/sql? are there any routines to get them?

Hi, I have oracle table for Leave LeaveNo FromDt ToDt 1 01/01/2010 31/03/2010 2 01/02/2010 31/05/2010 3 01/04/2010 30/04/2010 4 25/04/2010 15/05/2010 5 01/05/2010 31/05/2010 I want find out who was leave on 01/04/2010 to 30/04/2010. how to write oracle sql? tks in advance kartheeee

I need a little help with a query . I have attached an example table (roughly) in attached picture. The table has a serial number, a supplier_id and a weight column. We need to retrieve FOR each supplier the row that has maximum weight. There could be duplicate rows if …

I am trying to execute a script, it gives me the error SP2-0640: not connected I then select to connect, type in my username, password, service, and select SYSDBA as the connect. I then get the error ORA-12505: TNS:listener does not currently know of SID given in connect descriptor. I …

which other language can i use to develop an interface with oracle as the data source.?? neone....please help...

Hello Experts, I have following tables: Table_1: C_ID Inst_No Paid_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 13/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010 [/COLOR] Table_2: C_ID Inst_No Today_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 12/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010[/COLOR] Now, from the above two tables I want to display only …

Hi, Iam using ms sql server.Iam using a hospital management system .I need to find the last visit of the patient,only the last visit date,How can i do that?I think that it is as same as the latest published text,one of my friend told me,But how can i do that? …

i am trying to install developer edition 2000 on xp, but after clicking the autorun file nothing happens, though two processes appear in windows task manager, these are 1) sqlstp.exe 2) setupsql.exe but both are using '0%' cpu use and taking some memory. i tried so many things..really fade up. …

Every once in a while I run into this problem and finally decided to consult the experts. :) I insert foreign characters (Czech letters) into my MySQL database and see them there. They look fine. But when I try to retrieve them using PHP they come out with question marks …

Show the details of sales orders which are paid more than 14 days after the date of the sales order. SQL: SELECT SO.OrderID, D.DistributorID, D.FirstName, D.SurName, SO.OrderDate, P.PaymentDate, P.PaymentAmount FROM SalesOrder AS SO, Distributor AS D, Payment AS P WHERE D.DistributorID=SO.DistributorID AND SO.OrderID=P.OrderID AND DateDiff('yyyy',PaymentDate,Date( ) ) - DateDiff('yyyy',OrderDate,Date( )) …

I have the following table: [CODE] mysql> describe LEVEL1_CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(50) | YES | | NULL | | | BALANCE | …

how to insert username and password into database with connection in c# please give me reply sir

I am trying to make a query which will search for the ID's 5, 6 and 23(Those are just random numbers and could potentially be more). Rather than making a loop in my code to query each separate ID I was wondering if it was possible to query them all …

Greetings, I've got a query that I'm struggling with, this is the first time that I am encountering this type of query. I have two table as shown below. xid is the primary key in parent_tbl1, while xid is the foreign key in child_tbl2 parent_tbl1 [CODE]xid pub 1 1 2 …

Hi I m thinking about combined key system. say i have mysql table having field 1. user_name 2. father_name 3. mother_name 4. Address Now I can mark [B]user_nam[/B]e field as key for u[B]nique value[/B]. But I dont want that. I want that same user name is possible but same [B]user …

I need help guys, I want to be able to extract text from a string. This is an example of the string: @ ANSI 6360100102DL00390204ZF02430034DLDAACRUZ,JULIO,MIGUELDAG626 SIESTA KEY BLVD APT 434DAIDEERFIELD BEACHDAJFLDAK33441-0000 DAQC620433894240DARE DASA DAT DBA20141124DBB19891124DBC1DBD20080801DBHN DAU511 ZFZFA ZFB ZFCR050808010243ZFD I wanna be able to extract "CRUZ", "JULIO", "626 SIESTA KEY …

help me to autodecrement a field in a table when delete any entry from table example: !-------------------------- !id name userno !-------------------------- ! 1 harry 101 !-------------------------- ! 2 abc 102 !-------------------------- ! 3 xyz 103 !-------------------------- ! 4 xyz 104 !------------------------- if we delete 3rd entry from table than 104 …

I am not really looking for anyone to hold my hand through anything, but I am looking for someone to direct me to meaningful data/literature on the subject be it books/websites/videos/etc. I work for a small family business that repairs specific types of production machinery. We have a database that …

Here is my code. INSERT INTO employees (1.Last_Name,2.First_Name,3.Title,4.Title_of_Courtesy5.,BD,6.Hire_Date,7.Address,8.City,9.State,10.Zip,11.Country,12.Extension,13.Notes,14. Reports_to,15.Photo); VALUES (1, 'Smith', 'Janet', 'Sales Manager', 'Mrs.', '12-30-1974', '08/05/2000', '123 My Street', 'canton', 'OH', '44720', 'USA', '4632', 'MBA from Ashland University', 'Andrew Fuller', 'No Photo Available Yet'); Here is error message...Msg 102, Level 15, State 1, Line 2 Incorrect syntax near …

Hi! I need help to design an structure and the relationship. I need to create 4 tables: REGION, SUBREGION, CITIES and COUNTRY and do the relationships I have this: Table: REGION [CODE]CREATE TABLE REGION( REGION VARCHAR(2), REGION_NAME VARCHAR(200), );[/CODE] Values: REGION REGION_NAME 1 Africa 2 Americas Table: SUBREGION [CODE]CREATE TABLE …

Hi There. Is it possible to use the LOAD DATA LOCAL INFILE command from a crontab or what will the best way be of importing a csv on a hourly basis. Regards

hi, i have been trying to work out how to list all the users on the database for my website with a particular access level and also only the user id that the client is associated to however i end up with duplicated users. here is my query so far …

Not sure if many ppl here use navicat, but I am somewhat confused by the way data entries are handled through my page and how that interacts with my local db server and my remote db server. For example, at work I am sometimes working on cfm templates on my …

I Can't upload imige as my database donot support update although i give all previliges to the user root.Whats the problem?? Please Any one help me.The same code work on local PC. The link is: [URL="http://csefriends.com/index.php?page=auth/change_image.php"]http://csefriends.com/index.php?page=auth/change_image.php[/URL] The code is given below: [CODE] <?php $id=$_SESSION['userid']; $name=$_POST['name']; $fname=time(); $type= ".jpeg"; $fname = …

I am facing a query performance problem. While connecting to MySQL database through different Users methodology. Tell me does connecting by IP address user has over head. Like connecting using user@locahost or user@host-ip-address Is there any performance-wise difference by connecting using any of this user. I am getting a massive …

Hello All- I'm in the process of getting started a complete website for guidance and discussion about a new type of banking/lending. I would like to offer my fellow investors or potential investors greater access to slice and dice the data of one of the key companies involved in this …

I've been trying for a few hours now, and to be honest I'm getting fed up of it not updating the table!!!:icon_sad: [CODE]$sql="UPDATE list SET title='$_POST[title]', console='$_POST[console]', system='$_POST[system]', tv='$_POST[tv]', sram='$_POST[sram]', chips='$_POST[chips]', size='$_POST[size]', md5='$_POST[md5]', sha1='$_POST[sha1]', work='$_POST[work]', error='$_POST[error]', retrode='$_POST[retrode]', comments='$_POST[comments]' WHERE ID='$_POST[id]'"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 …

This is the part which searches and add the result to the 'pass' variable. At one stage I was getting a resource id number and found to get around that, but when I do this I get nothing on the pass variable [code] $result = mysql_query("SELECT `Pass` FROM `wiki` WHERE …

Hi all, I hope you are well. I have a very quick question for you please. I have a table with x rows and y columns. I need to select the top 100 rows ordered by col2 for eg. Further, I need to select only one row for a particular …

Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN [CODE] [Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28] [/CODE] Apparently TSQL doesn't like the "!" from Access: [CODE] SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center …

Ok back again. lol I just purchased a new hosting provider and was trying to transfer my database over to my new site. I exported the tables using Navicat and "tab" as the delimiter. I have three tables and they all saved as text files and look fine when I …

Hi I have 2 tables say A and B. Table A has EmpID, First Name and Last Name. Table has Award Recipient, Award Presenter ID(EmpID format). I want to write a select query where I want to fetch First and Last name of the Award Presenter from table A based …

Hi, Please let me know whats wrong with syntax of the following query, its written in MS Access format: Select count(*) from [Demographics/Job Data Table] D1 WHERE EXISTS (Select (*) from [Demographics/Job Data Table] D2 where [D2].[Supervisor ID] = [D1].[Employee #] and [D2].[Termination]=Yes) I am getting a syntax error message …

how to insert and retrieve a 20mb pdf file from mysql database?

Hi all I have a table that has a datetime column. What I'm trying to do is select the time only like one does when selecting only the day or month from a date column (eg SELECT day(date)) Can anyone tell me how to get this right. Using the following …

HI All, my requirement is as below: lets product name is "aaa bbb ccc". Now in search coding i have use LIKE statement. [CODE]"... where product_name LIKE '%".$keyword."%'"[/CODE] Now when user insert 'aaa' or 'bbb' or 'ccc' or 'aaa bbb' or 'bbb ccc' search works. But if user insert 'aaa …

Hi, Im having a problem with this image uploading thing..:( I was able to upload the image to a folder in the server,but the problem is I dont know how to set the path in the database.Every time after uploading I set the path manually.And I could be able to …

i need to start designing a hospital database ,where it includes the administration block,accounts,employeers,patients ,which software should i use

I have written the following Stored Procedure: [code] USE [BHPropertyInfo] GO /****** Object: StoredProcedure [dbo].[usp_UnitAvgByRM] Script Date: 08/26/2010 16:47:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE [dbo].[usp_UnitAvgByRM] -- Add the parameters …

i want to use federated tables in my db and not sure how to set them up in phpmyadmin...? does anyone have a solution for me...?

How exactly do I transfer data from my local server to my remote server. I had been using Navicat, but want to do it using myPhpAdmin, if possible. Thanks for any help in advance.

Hi can you pls any one let me know" How to delete duplicate records from a table in oracle 9i