SQL Query Syntax

May 9, 2008 07:37pm pdt

250 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

Loading Advertisement...

	[x] Neglected Question
	Neglected questions are any questions that either have not yet been addressed by an expert, or a solution has not been awarded, and may be eligible for bonus points (see your profile page for details).

	Title	Zone	Views
1	Need help with SQL Query	SQL Syntax	3676
2	SQL UPDATE statement for multiple rows, multiple columns	SQL Syntax	1100
3	Converting string date to datetime	SQL Syntax	704
4	Using IF THEN ELSE in SQL*Plus	SQL Syntax	699
5	Oracle 10 formatting a left outer join multiple conditions	SQL Syntax	582
6	Concatenate string using Group By	SQL Syntax	541
7	syntax for left outer join	SQL Syntax	502
8	Convert TimeStamp	SQL Syntax	474
9	SQL without inner join/subselect	SQL Syntax	400
10	VB .NET SQL Handling NULL values using insert into	SQL Syntax	346

	Title	Zone	Views
1	Need help with SQL Query	SQL Syntax	3676
2	UPDATE with INNER JOIN SQL Server	SQL Syntax	2200
3	Nested CASE/IF statements in MS SQL Server 2000	SQL Syntax	1490
4	Removing decimal places from a number SQL Server 2000	SQL Syntax	1252
5	How to get row number in sql?	SQL Syntax	1229
6	VBA/Excel SQL Query	SQL Syntax	1142
7	SQL UPDATE statement for multiple rows, multiple columns	SQL Syntax	1032
8	Create Autonumber in QUERY not TABLE in Microsoft Access	SQL Syntax	929
9	Insert date into SQL Server 2005 Table	SQL Syntax	860
10	T-SQL Loop through records of a query	SQL Syntax	766

Date	Points	Title	Comments
05/09/2008	125	Query to find duplicate in one field AND non-duplicate in another	2
05/09/2008	500	SQL Query help (using seq NEXTVAL or CURRVAL with UNION)	0
05/09/2008	500	Cannot have aggregate function in WHERE clause	15
05/09/2008	500	SQL Select statement	0
05/09/2008	500	Remove duplicates	9
05/09/2008	500	Building SQL statement based on criterias table	3
05/09/2008	500	Add Conditional Formatting To A Matrix Value Based On Another Matrix Value	0
05/09/2008	500	MySQL query result issue	2
05/09/2008	500	A Guide to ADO recordsets for a DAO programmer?	0
05/09/2008	500	SQL Query	19