Purchase Solution

Writing query for SQL using NESTED-SELECT statement

Not what you're looking for?

Ask Custom Question

I have a list of incomes (in column labeled Income) in a table labeled Jobs. I need to find the second highest number in the income column. I know that the MAX function finds the highest, but how would I find the second highest income using a NESTED-SELECT statement???

Purchase this Solution
Solution Summary

The expert writes a query for SQL using NESTED-SELECT statements.

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

View More Free Quizzes
Related BrainMass Solutions

  • features and uses of SQL

    A subquery is a select-from-where expression that is nested within another query. A common use of subqueries is to perform test for set membership, make set comparisons, and determine set cardinality.

  • Writing SQL Queries Using a Database and Tables

    249588 Writing SQL Queries Using a Database and Tables Write SQL queries (SELECT statements) using BETWEEN, LIKE, UNION, and GROUP.

  • SQL Database

    Use the updated database to write the following queries, using the SQL GROUP statement: MAKE SURE TO USE THE GROUP METHOD - Select employees' last names and group them by EEO-1 classification.

  • Using a semicolon (;) in MS Access

    And finally, in order to use the ";" in the query (searching for a string with a ";" in it) you need to use " around it. SELECT * FROM employees WHERE name = ";" In SQL a semicolon (;) is intended to end a SQL statement.

  • data manipulation capabilities

    The syntax of using exception handling is as follows: BEGIN TRY -- SQL statements END TRY BEGIN CATCH -- SQL statements END CATCH TRY/CATCH blocks can also be nested.

  • Using OR, AND, ANY, and ALL with SQL queries

    For example: SELECT * FROM mytable WHERE id > 100 AND age < 65; This statement selects all the items from the table where the id is greater than 100 AND the age is less than 65. Both conditions must be met.

  • SQL Server Database

    Notice that the query displays all duplicate records. Query 4 (SELECT GROUPORDER): Write a SQL statement that displays the average salary of employees by EEO Classification.

  • Structured Query Language Skills

    My suggestion is to write the SQL statement for the each condition and use CREATE table to make a table using the appropriate WHERE condition.

  • SQL Statements To Run In SQl Server

    Submit each query and its results paste into Word Document Using the database included write the following queries using the SQL GROUP statement: ?

View More Related Solutions