SELECT

SELECT will carry FULL Table scan if the Primary Key attributes are not specified. Behaves like a GetItem otherwise.

partiql-select

  • Part
SELECT LoginAlias,FirstName, Designation 
FROM Employee
WHERE LoginAlias IN ['rajs','johns']
ORDER BY LoginAlias DESC

Example : Using the functions

  • Find all employees who have ‘java’ in their skills
SELECT * 
FROM Employee
WHERE Skill Contains(Skills, 'java')
  • Find all employees with first name begining with J
SELECT FirstName FROM Employee
WHERE begins_with(FirstName,'J')