-
Rudy Limeback has worked with commercial databases since the mid-1970's, starting with IDMS, a Codasyl network system, and progressing through IBM's DB2 and Microsoft's SQL Server relational databases. He has developed data warehouses and transactional databases, always with an emphasis on making them easy to use for developers and end users alike. He specializes in writing SQL statements that are simple and easy to maintain. Rudy now operates r937.com, developing databases for use with dynamic Web sites.
-
Do you have a question for our experts?
Contributions from Rudy Limeback, SQL Consultant, r937.com
- Using the SQL GROUP BY clause for counting combinations
- How to use an SQL CASE expression
- How to check SQL query construction with the Mimer Validator
- How to use string functions to make an SQL join
- How to sort an SQL UNION query with special ORDER BY sequence
- An SQL solution for a customer order homework problem
- Using SQL date functions to get totals for last three days
- How to use SQL's POSITION function with substrings
- Using CASE in the SQL ORDER BY clause
- What's the difference between an SQL inner join and equijoin?
- Using an SQL SELECT statement from a non-existing table
- Using the SQL date function to find aggregate totals by month
- How to return multiple values for THEN clause in an SQL CASE expression
- Using LEFT OUTER JOIN query to get zero row counts in SQL
- Should I try to avoid a LEFT OUTER JOIN in SQL?
- Can I concatenate row values in SQL?
- How to write an SQL query for two foreign keys to the same table
- How to create an SQL CHECK constraint for two letters
- Tips for derived tables in SQL and using FULL OUTER JOINs
- How to write an SQL query using GROUP BY for row analysis