How to select Distinct records from a table in Sql server

In tables some of the columns may contain duplicate values. But you want to list out the (distinct) values of a coloum in that table. The DISTINCT keyword can be used to return only distinct (different) values. First of all create a table. create table dept_test( Deptno int,dname varchar(20),loc varchar(20)) Then insert records into the table you

How to use percentage in Microsoft Excel

To show a number as percent in Microsoft Excel, you have to apply  percentage number format in excel to that coloum. To apply this, select the cell, and then click the Percent button.     When you apply percentage formatting to a cell that already has number , Excel multiplies that number by 100 and adds the

How to Optimize JPEG (JPG) images for Good Quality and Small Size

How to Optimize JPEG (JPG) images for Good Quality and Small Size The image compression techniques have their origin in the necessity of reducing the size of the file used to store the image, which is huge when compared to storing text (a 800×600 24 bit color uncompressed image needs 1440000 bytes or 1.37 MB).