Search:

www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript Technical Guides Sybase Oracle UNIX Javascript After Work The best club in Chicago for Chicago Singles is Highlife Adventures! Are you looking for a Jersey Girl T-Shirt ? Kyoto Sushi in Chicago, on Lincoln Ave. Moody's Pub in Chicago, has great burgers Skylark in Chicago, on Halsted .. excellent Friday fish fry! Sybase » Transact-SQL » Coding » Transact SQL: Finding duplicate rows in a table       This example finds cargo records with have duplicate destination ids. 3> select cargo_id, dest_id 4> from routing t1 5> where 6> ( select count(*) 7> from routing t2 8> where t2.dest_id = t1.dest_id ) > 1 9> 10> go Sybase : Related Topics Sybase : Transact-SQL : Transact SQL: numeric functions Sybase : Transact-SQL : Transact SQL: string functions Sybase : Transact-SQL : Transact SQL: date/time functions Sybase : Transact-SQL : Transact SQL: misc functions Sybase : Transact-SQL : Transact SQL: Conditionals Sybase : Transact-SQL : Transact SQL: looping constructs Sybase : Transact-SQL : Transact SQL: Cursors Sybase : Transact-SQL : Transact SQL: Complex Updates Sybase : Transact-SQL : Using Temporary Tables Sybase : Transact-SQL : Inner/Outer Joins Sybase : Transact-SQL : Isolation Levels Sybase : Transact-SQL : Reporting: SQL Performance and Tuning Sybase : Transact-SQL : Case Statement Sybase : Transact-SQL : Date processing: stripping time from datetime Sybase : Transact-SQL : Safely delete a large number of rows without blowing the t-log Sybase : Transact-SQL : Transact SQL: date/time formats Sybase : Transact-SQL : Creating a stored procedure Sybase : Transact-SQL : Custom query plans Sybase : Transact-SQL : Rowcount setting - limiting result sets Sybase : Transact-SQL : Ranking Data - with Duplicates Sybase : Transact-SQL : Forcing an index in a query Sybase : Transact-SQL : Median Calculation, with pure SQL Sybase : Transact-SQL : Lead and Lag with pure SQL Sybase Web Site Sybase Mobile Web Site Oracle Web Site

Site Index

About this Guide to Sybase, Oracle, and UNIX

Contact Us

Advertise on this site

Copyright © 2008 Citisoft Inc All Rights Reserved.