Purchase Solution

Query Return Results Table Values

Not what you're looking for?

Ask Custom Question

I attached a database. In it is a table named Table1 with these values:
COLUMN 1 COLUMN 2
E 5
F 6
G 7
H 8
I 9
J 10
K 11
L 12
A 1
B 2
C 3
D 4

Why wont this query return any results?

SELECT Table1.COLUMN1, Table1.COLUMN2
FROM Table1
WHERE Table1.COLUMN2 = 7;

Attachments
Purchase this Solution
Solution Summary

The expert examines query return result table values.

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

View More Free Quizzes
Related BrainMass Solutions

  • SQL script to sort numbers across columns

    The script SQLQuery-CallSortByColumns.sql contains the SQL query to run against this sample data. It is very simple SELECT query with call of the user defined function to return an extra sort column.

  • Subquery and Join

    As we may know, an outer join uses the plus sign (+) operator to tell the database to return all non-matching rows with NULL values.

  • Query on data dictionary views (classmate schema) in oracle

    Write a query, based on data dictionary views, reporting a table's name, number of rows, average row length, column name (in order they appear in the table), the average column length, and the high and low values found in each column (the values are in

  • SQL pattern matching with MS Access

    The simple answer to your question, then, is that the first query doesn't return any results because it's an exact match query. This solution shows how to do pattern matching in a MS Access SQL query.

  • Write SQL queries using Between, Like and Union.

    return appropriate results.

  • Write a SQL query that returns the names of the students

    Order the results by major (in the case of a tie) and then alphabetically by last name and first name.

  • Query Questions and Results

    411564 Query Questions and Results Q4: Write a query to produce the result using the table website.

  • data manipulation capabilities

    INTO @GradeTable VALUES ('A') ELSE IF @average >=80 INSERT INTO @GradeTable VALUES ('B') ELSE IF @average >=70 INSERT INTO @GradeTable VALUES ('C') ELSE INSERT INTO @GradeTable VALUES ('F') RETURN END The following query uses the APPLY

  • SQL Statement for Grades

    Also this table will contains redundant values in Student Names, so we use distinct keyword to select only the students who have Grades larger then the Average grades.

View More Related Solutions