Tag: databases

One Value

More than One Value

No Value

User Defined Function will not return Value

Stored Procedure

Function

Table

View

Min( )

Sqrt( )

Sum( )

max( )

Open

Get

Extract

None of the Above

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

None

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT LastName>'Hansen' AND LastName

None

SORT BY

ORDER BY

SORT

ORDER

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons ORDER FirstName DES

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

None