Lab Sql

I have a .Net system that I am writing which needs to be able to retrieve an oracle geometry field … Read more Oracle Sdo_geometry Tostring()?

I am a SQL Novice in need of some advice. What is the most efficient (fastest running query) way to… Read more Optimal Oracle Sql Query To Complete Group-by On Multiple Columns In Single Table Containing ~ 7,000,000 Records

God day! I am running an extract of our Rolodex and including some user-defined fields, as you can … Read more Duplicate Resluts

i have a common situation here. I want to select all posts and its comments for a specific user. Fo… Read more Select All Post And Its Comments For A Specific User

I would like to take biggest sequence number for each client Id (biggest sequence number will be ca… Read more Selecting The Highest Seq Number By Nested Joining

Supposing we have the following records in an SQL Server table. Date 19/5/2009 12:00:00 pm 19/5/200… Read more Sql Server Server Query - Count Distinct Datetime Field

I'm new to CodeIgniter and ORM, I hope you guys can help me with this. The question table: CREA… Read more How To Insert Into A Table Join Other Table Using Activerecord In Codeigniter?

The trick with this compared to the other questions (e.g. 'Oracle convert rows to columns')… Read more Oracle Sql - Convert N Rows' Column Values To N Columns In 1 Row

How would i write an expression that gives me the difference between two dates in days, hours, minu… Read more Oracle Date Subtraction

Say I have columns 'a' and 'b'. A record is deemed 'ready' if !a || b. Ho… Read more How Can I Order By According To Some Boolean Logic?

After I run the program, I add the data, and then i get this message: implicit conversion from dat… Read more Implicit Conversion From Data Type Varchar To Varbinary Is Not Allowed

my query: SELECT * FROM messages_status mst INNER JOIN messages msg ON mst.m… Read more Select Last Message Of Conversation For Each Conversation In Mysql

I have two tables, an Orders table which contains a list of a users orders and a OrderShippingCosts… Read more Using Sql Sum With Case Statement Containing Inner Select

I'm getting this compile error message. How do I solve it? Error 28 'WindowsFormsApplica… Read more How Do I Solve This Compile Error?

I have an application which potentially does thousands of inserts to a SQL Server 2005 database. If… Read more Sqltransaction Has Completed

I was reading this article. It says : That character is represented at the value %uff1c. If this … Read more Validaterequest Fault Or Sql Server Bug?

I am trying to connect to SQL server through an asp.net page and I am getting this error: Cannot op… Read more Login Failed For Sql Server User Through Asp.net Page

I am working in sqlite db in my application using c++ linux. I have a requirement to replicate the … Read more Regarding Sqlite Replication

I'm writing a function for an Android app, that should get the first 8 entries (names of cities… Read more Using Like And Limit In Sqlite Queries In Android

I have a table, tblstars_new, which is updated weekly from the client. I have another table, tblst… Read more Write A Merge Statement For Mis-matching Values