SQL

EXPERT TECHNICAL ADVICE: 1 - 3 of 673

SQL EXPERTS
			Rudy Limeback SQL Consultant ASK A QUESTION

	How to write an SQL query using GROUP BY for row analysis 11 Sep 2008 EXPERT ANSWER - SQL expert Rudy Limeback explains how to write a SQL query using GROUP BY to retrieve the students who have all three rows in a skills table.

	How to return a zero in SQL instead of no row back for a select count 11 Sep 2008 EXPERT ANSWER - Want your row to return a zero instead of getting no row backs for some combinations when doing a select count in SQL? Find out how here.

	Using nested SQL string functions to find ERP customer values in a table 10 Sep 2008 EXPERT ANSWER - SQL expert Rudy Limeback explains the value of nested SQL string functions when extracting the ERP customer value for all rows in a table.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL

SEE ALSO - Topics Related to SQL:  Data Warehousing, ETL, and business intelligence, (Archive) Database Performance Tuning, (Archive) Database Administration and Development, Oracle Internals, (Archive) Oracle Applications, Database Backup and Recovery, Oracle Application Server, PL/SQL, Oracle Performance Tuning, Managing an Oracle shop, RAC and Availability, Database Design and Architecture, (Archive) SQL and PL/SQL, (Archive) Database Installation and Upgrade, (Archive) Database Security, (Archive) Data Warehousing and Business Intelligence, (Archive) Database Design, (Archive) App Dev: PL/SQL and XML, (Archive) Database Installation/Upgrade/Patches, SOA and Integration, E-Business Suite