• Law firm cuts SQL query times and future-proofs with Tegile hybrid flash

    Reading-based Boyes and Turner opts not to replace Dell EqualLogic SAN and brings in hybrid flash array from startup Tegile

    Antony Adshead2,350 pointsBadges:
  • I want to sort the data with SQL Query.

    I want to sort the data on customer table on Address field. Address field contains data like this: Address Preet Street ,India. John Street, India. 34 cyber tower,Hyderabad. 2 keivn road, Bangalore. I used the below query to sort the data. Select address from customer order by address Below are the...

    PreetMaan85 pointsBadges:
  • SQL OUTER JOIN sample statements for queries

    Discover sample SQL OUTER JOIN statements and result sets in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." Using sample databases and complex JOINs, these examples will help you master the process of solving SQL queries using OUTER...

    ITKE440,705 pointsBadges:
  • The EJB Query Language (EJBQL)

    You might have noticed that different EJB container vendors have different ways of defining the queries for finder methods. Some require you to specify an SQL query, while others have their own query languages. EJB 2.0 introduces a standard EJB query language so that you need to write your finder...

    ITKE440,705 pointsBadges:
  • The most dangerous game: Hunting down bad SQL query performance

    SQL Server is faster when the queries behind your applications are faster. Learn how to spot bad SQL query performance, and then work with developers so you can improve throughput.

    ITKE440,705 pointsBadges:
  • Obtaining COUNTs for males and females in one SQL query

    For my table the gender column has only two values; F and M. I would like to do a count of both genders in one SQL query.

    rlimeback1,400 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.