Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Filtering (WHERE) and Sorting Data (ORDER BY) in Oracle 9i
- This paper covers filtering of rows using the WHERE clause and sorting of retrieved data using the ORDER BY clause. The WHERE clause applies to both queries and most DML commands; the ORDER BY clause applies to queries only. The WHERE clause extends the syntax of the SELECT statement, allowing...
- Tags: Oracle Corp., Clause, Oracle9i, Databases, Enterprise Software, Software, Data Management
- White papers 2004-11-05
- cannot work in the same industry for one year after resignation?
- Hello Forum,I finally decided to resign gracefully and professionally from my current employer. But I found a clause in my contract signed three years ago. It said that I cannot work for the same domain for one year after my termination except I am fired. I wasn't told exactly at...
- Tags: clause, industry, jiansec, networking, resign
- Discussion threads 2006-02-06
- Learn the ins and outs of filtering data in MySQL with the WHERE clause
- This sample chapter, taken from MySQL Crash Course, discusses how to use the SELECT statement'sWHERE clause to specify search conditions. This sample chapter, taken from MySQL Crash Course, teaches you how to use the SELECT statement'sWHERE clause to specify search conditions, such as quality, nonequality, greater than...
- Tags: Sams Publishing, MySQL, Open Source, Databases, Enterprise Software, Software, Data Management
- Book chapters 2006-03-14
- Use the GROUP BY clause to write SQL queries that group and aggregate data
- Introduction to SQL, long the definitive SQL tutorial for database professionals, has been updated to reflect the latest SQL standards and newest versions of today's leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL. Throughout, case study examples and hands-on exercises illuminate key SQL concepts, techniques, and statements....
- Tags: Clause, SQL, Addison-Wesley, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Book chapters 2007-01-03
- Use the GROUP BY clause to aggregate data in MySQL
- SQL is a compact and powerful language for working with databases, and MySQL offers a SQL dialect with particular power. SQL for MySQL Developers: A Comprehensive Tutorial and Reference helps you master this version of SQL and take advantage of its full potential by using case study examples...
- Tags: MySQL, SQL, Addison-Wesley, Programming Languages, Databases, Open Source, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Book chapters 2007-04-26
- On Ignoring, Locking, and Parsing
- There's a programming construct, WHEN OTHERS, in PL/SQL that the author wishes weren't there. This clause, when used in an exception block, catches any unhandled exceptions. There are times when this is useful, such as for logging errors. But the problem the author sees is that far too many people...
- Tags: Oracle Corp., Error, Programming Languages, Databases, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers 2007-07-01
- SQL retrieving only rows of a size
- I want to examine the grades of students only if there are at least 10 students in the class. I think I should be able to write something like this, but I get all classes. What am I doing wrong?selectshrtckn_subj_code,shrtckn_crse_numb,shrtckg_grde_code_finalFROM shrtckn LEFT JOIN shrtckg ON shrtckg_pidm = shrtckn_pidmWHERE (SELECT count(b.shrtckn_pidm)...
- Tags: Banner, SELECT, SELECT COUNT, john.a.wills@..., programming, SQL
- Q&A 2006-07-18
- Using Grouping Sets in SQL Server 2008
- A neat new feature in SQL Server 2008 is the GROUPING SETS clause, which allows you to easily specify combinations of field groupings in your queries to see different levels of aggregated data. Today we'll look at how you can use the new SQL Server 2008 GROUPING SETS clause to...
- Tags: Microsoft SQL Server 2008, Microsoft SQL Server, Clause, GROUPING SETS, SQL Server 2008 GROUPING SETS Clause, GROUP, SalesHistory, SalePrice, AVG, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-10-03
- Dealing with case and accents in SQL Server
- Question regarding indexes vs. collationsThanks, nice article! I work with lots of character sets including ISO 8859-2 (e.g. Polish), Cyrillic and others, as well as ISO 8859-1, and so usually use Unicode data.Being able to set collation on a specific query could come in very handy for me sometimes.I...
- Tags: Etaoin Shrdlu, server, Microsoft SQL Server, collation
- Discussion threads 2007-05-01
- Simulate variable arguments in PL/SQL
- Variable IN ListOften, we need to pass variable arguments to "IN" clause. The most used workaround is to pass a string and split it inside PL/SQL to create a table that can be used as the expression for IN clause. This has a no. of limitations - e.g., it affects...
- Tags: Programming languages, Databases, clause
- Discussion threads 2005-06-15
- Learn the ins and outs of filtering data in MySQL with the WHERE clause
- This sample chapter, taken from MySQL Crash Course, teaches you how to use the SELECT statementÂ’sWHERE clause to specify search conditions, such as quality, nonequality, greater than and less than, value ranges, and NULL values.Title: MySQL Crash CourseISBN: 0672327120Published: December 2005Author: Ben FortaChapter: Chapter 6: Filtering DataPublished by Sams
- Tags: MySQL, MySQL Crash Course, clause, Published, Value at Risk
- Download resources 2006-03-14
- Exploring the window functions in SQL Server 2005
- SQL Server 2005's window functions allow you to look at different levels of aggregation all at one time. Here's how to use the OVER(…) clause to gather a collection of statistics. Window functions in SQL Server 2005 have nothing to do with Microsoft Windows; rather, they create data...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Construction, Databases, Arthur Fuller, SQL Server window, window, clause, Window Function, SQL Server Newsletter, TechRepublic Inc., Enterprise Software, Software, Data Management
- Technical articles 2007-03-19
- resign legal issue
- Hello Forum,I finally decided to resign gracefully and professionally from my current employer. But I found a clause in my contract signed three years ago. It said that I cannot work for the same domain for one year after my termination except I am fired. I wasn't told exactly at...
- Tags: clause, domain, IT DEPENDS
- Discussion threads 2006-02-06
- GeneMatics (exe)
- Population Genetics Software: Predicts the genotype of the child, given phenotype of the parents. Takes into account unlimited depth of family tree. Robustly handles partially specified data. Handles unlimited number of genetic attributes. Handles both autosomal and x-linked attributes. Software Features: intuitive click and drop graphical user interface; save setups...
- Tags: Setup, Tools & Techniques, Management
- Software downloads 2006-03-16
- Open your users' minds to open handles in Windows 2000 Server
- It's a common puzzle—you're trying to delete a file, but another, unidentified program is using it. In this Windows 2000 Server tip, Jim Boyce discusses handles, which can help identify all open files and end the mystery. Sometimes when users try to delete a file, they receive an...
- Tags: Microsoft Windows 2000 Server, Microsoft Windows 2000, Microsoft Windows, Servers, Jim Boyce, server, handle, Windows 2000 Server Tips Newsletter, Utility, Operating Systems, Software, Hardware
- Technical articles 2006-05-26
- domain name dispute
- My domain "charlestonalumnaedst.org" was stolen from me. The long and short is that I tried to transfer it on Oct 1, whereas it was to expire on Oct 3. The current registrar refused to give me the authority to transfer it. Then they expired it on Oct. 7....
- Tags: Domain names, Oct
- Q&A 2005-10-13
- GDI Watch Add-In For Visual Studio 2005 (msi)
- This Microsoft Visual Studio 2005 add-in allows you to watch the full content of Windows GDI handles while debugging your image processing or UI programs. The add-in looks and behaves like a regular watch window and it works with programs written in C/C++ languages. The add-in also supports all MFC...
- Tags: Microsoft Visual Studio, Microsoft Visual Studio 2005, Virgo Software, Microsoft Development Tools, C/C++, Development Tools, Software Development, Software/Web Development, Programming Languages
- Software downloads 2007-12-20
- Grand Theft Auto: Vice City vehicle editor (zip)
- This vehicle editing tool works with all the vehicles in Vice City. Customize any characteristic other than appearance. Make a fire truck that handles like a banshee, or a cabbie that handles like a police car. This works for helicopters, planes, motorcycles and even RC vehicles as well.
- Tags: Vehicle, Productivity
- Software downloads 2004-03-11
- Calculate columns and averages with SQL Server's HAVING clause
- Arthur Fuller gives a brief overview of SQL Server's HAVING clause and provides code examples that demonstrate how to use it. For instance, he shows how to use HAVING to test aggregates based on a child table. As an instructor of database language and usage, I find some ...
- Tags: Microsoft SQL Server, Databases, Arthur Fuller, clause, server, SQL Server Newsletter, Enterprise Software, Software, Data Management
- Technical articles 2007-01-22
- << Previous
- page 1 of 1
- Next >>
