Lab Sql

I am trying to optimize a query that does something like this: SELECT ... CASE WHEN (conditio… Read more Sqlserver Case Expressions - Short Circuit Evaluation?

I have 40+ columns in my table and i have to add few more fields like, current city, hometown, scho… Read more Mysql Table With 40+ Columns

If I run the following SQL query SELECT * FROM A LEFT JOIN B ON A.foo=B.foo WHERE A.date = 'Ye… Read more Sql Order Of Operations

If I want to fetch million rows in hibernate, how would it work? Will hibernate crash? How can I op… Read more Loading Million Rows In Hibernate

I am fresh to Codeigniter. I have a form which looks something like this. Solution 1: Multiple … Read more Codeigniter Insert Multiple Rows In Sql

Newish to Oracle programming (from Sybase and MS SQL Server). What is the 'Oracle way' to … Read more Oracle Sql Technique To Avoid Filling Trans Log