W3Schools
home HOME Tutorials | References | Examples | Forum | About
Search W3Schools :

SQL Basic
SQL HOME
SQL Intro
SQL Syntax
SQL SELECT
SQL DISTINCT
SQL WHERE
SQL AND & OR
SQL ORDER BY
SQL TOP

SQL Demo
SQL Try It

SQL Advanced
SQL LIKE
SQL Wildcards
SQL IN
SQL BETWEEN
SQL Alias
SQL Join
SQL INNER JOIN
SQL LEFT JOIN
SQL RIGHT JOIN
SQL FULL JOIN
SQL UNION
SQL SELECT INTO

SQL CREATE DB
SQL CREATE TABLE
SQL Constraints
SQL NOT NULL
SQL UNIQUE
SQL PRIMARY KEY
SQL FOREIGN KEY
SQL CHECK
SQL DEFAULT
SQL CREATE INDEX
SQL DROP
SQL ALTER
SQL INSERT
SQL UPDATE
SQL DELETE
SQL CREATE VIEW

SQL Functions
SQL AVG()
SQL COUNT()
SQL FIRST()
SQL LAST()
SQL MAX()
SQL MIN()
SQL SUM()
SQL GROUP BY
SQL HAVING
SQL UCASE()
SQL LCASE()
SQL MID()
SQL LEN()
SQL ROUND()
SQL NOW()
SQL FORMAT()

SQL Data Types

SQL Quick Ref
SQL Hosting
SQL Summary

SQL Quiz
SQL Quiz

Selected Reading
Web Statistics
Web Glossary
Web Hosting
Web Quality

W3Schools Tutorials
W3Schools Forum

Helping W3Schools

SQL FIRST() Function

previous next

The FIRST() Function

The FIRST() function returns the first value of the selected column.

SQL FIRST() Syntax

SELECT FIRST(column_name) FROM table_name


SQL FIRST() Example

We have the following "Orders" table:

O_Id OrderDate OrderPrice Customer
1 2008/11/12 1000 Hansen
2 2008/10/23 1600 Nilsen
3 2008/09/02 700 Hansen
4 2008/09/03 300 Hansen
5 2008/08/30 2000 Jensen
6 2008/10/04 100 Nilsen

Now we want to find the first value of the "OrderPrice" column.

We use the following SQL statement:

SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders

The result-set will look like this:

FirstOrderPrice
1000


previous next


Learn how your website performs under various load conditions

Web Load and Performance Testing   

WAPT is a load, stress and performance testing tool for websites and web-based applications. In contrast to "800-pound gorilla" load testing tools, it is designed to minimize the learning curve and give you an ability to create a heavy load from a regular workstation. WAPT is able to generate up to 3000 simultaneously acting virtual users using standard hardware configuration. Virtual users in each profile are fully customizable. Basic and NTLM authentication methods are supported. Graphs and reports are shown in real-time at different levels of detail, thus helping to manage the testing process.

Download the free 30-day trial!



Jump to: Top of Page or HOME or Printer Friendly Printer friendly page

W3Schools provides material for training only. We do not warrant the correctness of its contents. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2008 by Refsnes Data. All Rights Reserved.

Validate Validate W3C-WAI level A conformance icon W3Schools was converted to XHTML in December 1999
Shopping Cart
ASP.NET
Shopping Cart
WEB HOSTING
$15 Domain Name
Registration
Save $20 / year!
Buy UK Domain Names
Register Domain Names
Cheap Domain Names
Cheap Web Hosting
Best Web Hosting
PHP MySQL Hosting
Top 10 Web Hosting
Web Hosting Company
UK Reseller Hosting
Web Hosting
WEB BUILDING
Website Templates
Flash Templates
Website Builder
Internet Business Opportunity
Custom Programming
FREE Trial or Demo
Web Content Manager
Forms,Web Alerts,RSS
Download XML editor
HTML Tutorial DVD
EDUCATION
US Web Design Schools
HTML Exam
TRAVEL
FUNC Cheap Flights
YELLOW PAGES
www.nettkatalogen.no
www.gulex.dk
www.gulex.se
www.gelbex.de
www.teloos.fi
www.teloos.fr
www.teloos.co.uk
www.teloos.at
www.teloos.de