Different query method in SQL Server

 

    Here we are discussing about simple query technique used in sql server . Please go through the below example.

1. Use below query to crated temp Data set in SQL.

CREATE TABLE #TempTable (UserName VARCHAR(20),Age INT,Gender VARCHAR(10),Amount MONEY)

INSERT INTO #TempTable

SELECT 'Clark',27,'Male',500

UNION ALL

SELECT 'Jack_dani',29,'Male',100

UNION ALL

SELECT 'Libsa',18,'Female',1000

UNION ALL

SELECT 'Libsa',18,'Female',500

UNION ALL

SELECT 'Jp-dani',30,'Male',100

2. Query to select data contain underscore in User Name.

SELECT  * FROM #TempTable WHERE CHARINDEX('_',UserName) > 0

3. Query to filter column gender is Male.

SELECT  * FROM #TempTable WHERE Gender = 'Male'

4. Query to find sum of total amount grouping age column.

SELECT Age,SUM(Amount) As Total

FROM #TempTable

GROUP BY Age

5. Query to find the users whose age is greater than 27. 

SELECT  * FROM #TempTable WHERE age > 27