Kashipara.com is a community of ONE million programmers and students, Just like you, Helping each other.Join them. It only takes a minute: Sign Up
Job Resume TemplateHere list of most downloaded source code from kashipara.
This program is used to display the alternate odd number of records from the given table. In that, inner query and analytic function are used. ... [ Download Source Code ]
This program fetches the alternate even number of records from a given table. In this program, inner query and analytic function are used. ... [ Download Source Code ]
This program is used to fetch last five records from a given table. With the help of inner query, I have completed this program. ... [ Download Source Code ]
Program will show you how to fetch all the columns and those records having maximum of values of sales. In this, ROW_NUMBER function is used. ... [ Download Source Code ]
In this program, I have replaced last four characters of a column with 'XXXX'. For this, I have used string functions like STUFF, CHARINDEX, RIGHT. ... [ Download Source Code ]
I have created a SQL code which is used to find the percentage of Male and Female from a given table (that is from Gender column). In that code, I have used CTE, SUM and CAST function and CASE statement. ... [ Download Source Code ]
We have created a SQL code which is used to count Male and Female from a given table(that is from Gender column). In that code, I have used SUM function and also CASE WHEN-THEN END statement. ... [ Download Source Code ]
a my sql workbench based project in which the program depicts how to implement a join between two tables and how the data would look like after joining based on same column ... [ Download Source Code ]
a sql related project which depicts how to use foreign key to establish a relationship between two tables based on a same column ... [ Download Source Code ]