Monday , December 11 2017

Multirow Functions:-

Studyclues_MultiRow

Multirow Function:- These functions process group of Rows and Return one value. This functions are also called group functions or aggregate functions. 1.Max():- Returns Maximum value [crayon-5a2e845ce03e5552580683/] [crayon-5a2e845ce03f5710631322/] Maximum salary of managers? select Max(sal)from emp where Job=’MANAGER’ 2.Min():- Returns Minimum value [crayon-5a2e845ce03fb864800850/] [crayon-5a2e845ce0401484057265/] 3.Sum():- Returns total [crayon-5a2e845ce0407130209643/] 4.Avg():- Returns average …

Read More »

Expenses Manager and Money Saver

Gullak

Expenses Manager and Money Saver: now a days Managing personal income and expenses are very important. with a proper management we can reduce the unnecessary expenses to track your each expense and income, its better write down them.unlike the early days,now we can record all the transactions right after they …

Read More »

Parallel Space-Multi Accounts

Parallel

Parallel Space-Multi Accounts: As one of the top-ranked tool on Android, Parallel Space helps more than 20 million users log in to their multi accounts at the same time on one device! It also protects user privacy by making apps invisible on device with the Incognito Installation feature. So far …

Read More »

View Classification

Studyclues_Viewes

Views:-  View Definition:- A View is nothing but an image table or virtual table, which is created for a base table. A view can be created by taking all values from the base table or by taking only selected values from base table. There are two types views available in …

Read More »

JOINS

Studyclues JOINS

JOINS: Joins in SQL Server explained bellow (one by one):- These are used for retrieving the data from one or more tables at a time.Joins can be used in any of the following ways. 1.Equi-joins 2.Non-equi-joins 3.Self join 4.Cross join 5.outer join Sample Tables: Table 1:EMPLOYEE [crayon-5a2e845ce1ae1441993371/]   Table 2: …

Read More »

Talking Tom Gold Run Android Game

Talking Tom Gold Run Android Game: Fearlessly CHASE AFTER BAD GUYS, EXPLORE NEW WORLDS and BUILD THE COOLEST PLACE as you swipe your way to the top. Description: You’ve been robbed! Explore this endless runner as TALKING TOM and TALKING ANGELA to chase down the robber and get your gold …

Read More »

Special Functions

sql server special functions

Special Functions:- below are the Special Functions in sql server. 1.IsNUll():- Used to convert Nulls [crayon-5a2e845ce25a4590433542/] if expr1 is Null returns expr2 if expr1 is NotNull returns expr1 only [crayon-5a2e845ce25b0869575893/] Sal+comm as total sal from enp 1.select empno,ename,sal,comm,sal+comm as totalsal from enp. In the above case if something sal+Null= Null 2.select …

Read More »

The Olympics – Official App

The Olympics - Official App

The Olympics – Official App Gold medals, Olympic records, amazing athletes and magic sporting moments, plus everything you want to know about Rio 2016, Pyeong Chang 2018 and all past and future Olympic Games, now available at your fingertips : • Re-live top moments from Sochi 2014, London 2012, Vancouver …

Read More »
Page 5 of 11
1 3 4 5 6 7 11