• GROUP BY MySQL

    Hi, I have started working with a MySQL databse. I need a query that will either make use of "DISTINCT" or "GROUP BY" but that selects the record that has the highest 'VersionNumber' Can anybody suggest how I would achieve this? Thanks in advance.

    LewisT5 pointsBadges:
  • Importing Data GAL entries into Access 2007

    Need to import outlook GAL entries into Access 2007 & have the database updated when I change a field in the GAL entry.

    AGB25 pointsBadges:
  • Connection of Crystal Report 2008 with VB6.

    Please let me know the procedure to bring the controls of Crystal Report 2008 in VB6? What control has to be select and what coding should be use for the same? I'm using SQL 2000 as a back-end. Please help.

    Anishrohlx5 pointsBadges:
  • Which database is better: MySQL or NoSQL?

    We are e-learning company and have a product based on client server model. We are currently using MySQL but facing problems with the installation as it takes longer time to install all the prerequisites. Is there a better way or better database option available? Switching to NoSQL-Mongo DB will be...

    RyanHaris5 pointsBadges:
  • E-mail hacking

    How can I hack my own e-mail address? Is there software available for this (commercial or freeware)?

    Brainstorm225 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When I tried to insert 5000lines of HTML code to the variable in Java, I'm getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • FoxPro 2.6 for DOS

    When programs (small or large) runs in FoxPro 2.6 for DOS the CPU usage showing 100%. How can I solve this problem?

    Zarkos5 pointsBadges:
  • Database connectivity between Microsoft Access and C++

    How can I give database connectivity in code of C++, and my database is stored in Microsoft Access?

    Myinfy185 pointsBadges:
  • Case Statements SQL

    I'm running a query that returns a specific status code. However, within my query that specific status doesn't always exist and I get a null value. I would like to return another status when that is the case. I can't seem to get the case statement to work.

    Wilso01115 pointsBadges:
  • How to use API to access DB2 file on iSeries

    Gredon would like to access (search, read, insert, update and delete) a DB2 file on the iSeries with an API. He said he's searched the IBM manual, but he couldn't find the APIs that he can use. Can you help him? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • In-Memory Database

    What do you mean by In-Memory Database? Is it like loading of database data along with application? Please explain me how the In-memory database get loaded along with the application.

    Techy001340 pointsBadges:
  • Need to recover Microsoft Access database

    I have a task regarding access database. I and my organization is using access database  to maintain my access files in well mannered way. But due to varied reasons access file showing error message: Error 3112: Your access database got corrupted will not be able to show the database. Due to this...

    MarshallBurns5 pointsBadges:
  • Access MySQL on Linux from phpmyadmin on Windows

    Hi, First I'll describe my setup: Server 1: Windows server 2003 IIS 6 PHP 5.4.33 phpMyAdmin 4.2.9 Server 2: Ubuntu Server 14.04.1 MySql 5.5.38 PHP 5.5.9 I installed phpMyAdmin on my Windows server and configured it with two servers login. I can login to MySQL on my Windows Server and edit databases...

    sevynos35 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    I want to make the SQL connection with VB 6. How do I open the connection in SQL?

    Vishalngp15 pointsBadges:
  • Cloning my dual boot Ubuntu/Mac PC to another

    HI, I have some computers which dual boots Ubuntu and Mac. I need to do the same in around 20 PCs again! How can I do using less resources and time? (All PCs are of the same configuration). All computers can be connected via LAN. I think Norton Ghost is not a solution.

    Jibin405 pointsBadges:
  • How to fill Combo Box at runtime in VB 6.0?

    How to fill Combo Box at runtime in VB 6.0 ...I've used RecordSet object but rec.count of rs obj returns (-1). I have enough data in the DB. [Private Sub Form_Load() FillCombo End Sub Sub FillCombo() Dim rs As New ADODB.Recordset, SQL As String SQL = "Select Spare_Name from Spare" rs.Open SQL,...

    Spartanx5 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • Converting text string to numeric

    I am using Access 2003. I have a table with numbers that are shown as text data. I want to convert from text to numeric. Can this be done in a table or a query?

    SacramentoSil25 pointsBadges:
  • How can I change the collation name of a specific database?

    How can I change the collation name of a specific database?

    Nooshka5 pointsBadges:
  • Limit the number of rows returned by an Oracle query

    Would there be a way to make an Oracle SQL query behave like it contains a MySQL limit clause? So, for example, here's what I can do in MySQL: select * from sometable order by name limit 20,10 This allows me to get the 21st to the 30th rows (meaning skip the first 20, give the next 10). The rows...

    ITKE352,565 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following