
Featured
- 
            
              Find out a particular column throughout the database in PostgresqlPreviously got a situation where I needed to get t by Nitika.Verma
Tags
How to select second highest salary from a table?
                      This question is asked a lot in interviews, so here some of the methods by which one can get the second highest salary of an employee from a table.
Suppose the Employee is like this
	
		
			ID
			Name
			Salary
		
	
	Table: Employe... 
                      Compression and Decompression in SQL Server 2016
                      In the upcoming version of SQL 2016 a new component of COMPRESS and DECOMPRESS T-SQL functions is added. SQL Server 2016 provides built in functions for compression and decompression.The COMPRESS and DECOMPRESS functions can store and retrieve da... 
                      Creating xml from SQL query
                      This blog will show you how to create an xml from sql query having sql data. Write down the followng query to generate xml:-
WITH XMLNAMESPACES ('http://www.dossia.org/v2.0/xml/phr' as phr)
Select OrderResultID,OrderID ,PatientID ,SpecimenNum... 
                       
        
        
 
        
         
        
        