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
Today i am looking something on google and i found something very intresting their. Go to google search page. Search for Google gravity. Then click on the very first link. Wait for 2 seconds and you will be amazed what going to google page. Then search for anything and you will be a little more
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
Query to get total salary of a Department In organizations their are several departments.To calculate the total salary of that department in SQL server is so easy. Query: select deptno ,sum(basic) as total from emp group by deptno Here Deptno refers to Dept which salary you want calculate and basic refers to the Salary column
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).
In this article i will show you you how to get data from sql server in excel by run stored procedure in Microsoft Excel. 1. Open Microsoft Excel. 2. Go to Data tab. 3. Then Go to Other data source menu in it. 4. 5. Fill your details in pop-up box as shown in