Sql

SELECT EmpId
FROM EmployeeSalary
WHERE Project <>'P1';

1
SELECT TOP N * FROM EmployeePosition ORDER BY Salary DESC;

1
SELECT SUBSTRING(EmpLname, 1, 4) FROM EmployeeInfo;

1
SELECT EmpID FROM (SELECT rowno, EmpID from EmployeeInfo) WHERE MOD(rowno,2)=0;

1
SELECT EmpID FROM (SELECT rowno, EmpID from EmployeeInfo) WHERE MOD(rowno,2)=1;

SELECT * FROM Table_name WHERE EmpName like 'A%'

PREVIOUS	NEXT

Code Example
Sql :: in query in sql
Sql :: sqlite
Sql :: delete query
Sql :: primary key in sql
Sql :: delete duplicate sql
Sql :: full outer join in sql
Sql :: psql database does not exist
Sql :: select all same column value in sql
Sql :: sql select merge multiple values
Sql :: django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
Sql :: oracle sql first day of quarter
Sql :: remove accented characters in bigquery
Sql :: data structures in sql
Sql :: python connect to mysql in settings.py
Sql :: raven ql select count
Csharp :: asp.net data annotations email
Csharp :: c# calcualte proccess
Csharp :: c# read text file to list string
Csharp :: unity how to get y value
Csharp :: unity how to convert to byte
Csharp :: c# remove last character from string
Csharp :: c# check to see if dictionary key exists
Csharp :: c# new line in messagebox
Csharp :: rigidbody2d unfreeze position
Csharp :: dotnet build to exe
Csharp :: c# winform remove button border
Csharp :: Csharp convert string to double
Csharp :: c# get bytes from string
Csharp :: c# long to int
Csharp :: c# ip address translate localhost