Group by alias column name in sql server

DECLARE @tbltemp TABLE(
ID INT PRIMARY KEY IDENTITY(1,1), Name VARCHAR(MAX) DEFAULT '',Admission date
)

INSERT INTO @tbltemp(Name, Admission)
Values('manu',getdate()),
('raju',getdate()+2),
('lohith',getdate()-30),
('venu',getdate()+2),
('madhav',getdate()-30)
Select entrydate,count(Id) as noofstudents
FROM (
Select Id,Name,Admission as entrydate from @tbltemp
) subdata
group by entrydate

Comments

EncryptByPassPhrase and DecryptByPassPhrase in sql server

This Article explains you how to Encrypt and Decrypt a text in sql server EncryptByPassPhrase: Syntax: ENCRYPTBYPASSPHRASE ('PASSPHRASE', ‘text’) creating table Login table create table login(id int identity(1,1),username varchar(10),password varchar(100)) insert into login (username,password)values('Ramprasad',EncryptByPassPhrase('12','AAA')) insert into login (username,password)values('venkat',EncryptByPassPhrase('12','BBB')) insert into login (username,password)values('hemanth',EncryptByPassPhrase('12','CCC')) select * from login id username password 1 Ramprasad 2 venkat 3 hemanth now we are not able to see the passwords .To visible the Passwords we need to Decrypt the passwords DecryptByPassPhrase : Dec...

How to create task scheduler in C#

Today I will elucidate about undertaking scheduler in c# and how to booked on particular time in window.Today i will make an errand scheduler utilizing c# reassure application to call or expend rest web programming interface with intermediary to get information from sharepoint .This illustration use to devour web programming interface to call sharepoint to download report on neighborhood application catalog. How to make Task scheduler in c# application? Step 1:- Create a reassure application in c# Step 2:- You have to include Microsoft.SharePoint.Client library from chunk bundle in you application. utilizing System; utilizing System.IO; utilizing System.Net; utilizing System.Net.Http; utilizing System.Net.Http.Headers; utilizing System.Threading.Tasks; utilizing System.Configuration; utilizing System.Security; utilizing Microsoft.SharePoint.Client; namespace InsightTaskSchedular{ class Program { static void Main() { attempt { /to validate from share...

Alltechmania

Search This Blog