Saturday, 5 May 2018

difference between Count(*) and Count(Column Name)

Harry

 Count(*) vs Count(column_name)

We use count(*) to get the total number of records.

SQL>select count(*) from emp2;

Note:-There is no difference between count(*) and count(1) .

SQL>select count(1) from emp2;

But there is a difference between count(*) and count(column_name) .Count(*) return the total number of records of table and count(column_name) return the count of records that have not null value in that column.

SQL>select count(empno) from emp2;

See the reference screen


 

SYSDATE in Oracle

Harry

SYSDATE

SYSDATE is used to get the system date and time.This return values in format of "nls_date_time"
SQL>SELECT sysdate FROM DUAL;

Note:-We can change the format of nls_date_time for session by below command.

SQL>ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

Now you will get the result in above mentioned format.
 
SQL>SELECT sysdate FROM DUAL;


Below is expression list that can be used in different queries

 Examples:-

Thursday, 3 May 2018

Far Cry 5

Harry





Minimum System Requirements


CPU: Intel Core i5-2400 | AMD FX-6300 @ 3.5 GHz or better
RAM: 8 GB
OS: Windows 7 SP1, Windows 8.1, Windows 10 (64-bit versions only)
Video Card: NVIDIA GeForce GTX 670 | AMD R9 270 (2GB VRAM with Shader Model 5.0 or better)

Recommended System Requirements


CPU: Intel Core i7-4770 @ 3.4 GHz | AMD Ryzen 5 1600 @ 3.2 GHz or equivalent
RAM: 8 GB
OS: Windows 7 SP1, Windows 8.1, Windows 10 (64-bit versions only)
Video Card: NVIDIA GeForce GTX 970 or AMD R9 290X (4GB VRAM with Shader Model 5.0 or better)

Download The Game Here


Batman Arkham Knight

Harry





Minimum System Requirements


Processor: Intel Core i5-750, 2.67 GHz | AMD Phenom II X4 965, 3.4 GHz
Memory: 6 GB RAM
Graphics Card: NVIDIA GeForce GTX 660
Graphics Memory: 2 GB
Hard Drive Space: 45 GB

Recommended System Requirements


Processor: Intel Core i7-3770, 3.4 GHz | AMD FX-8350, 4.0 GHz
Memory: 8 GB RAM
Graphics Card: NVIDIA GeForce GTX 760
Graphics Memory: 3 GB
Hard Drive Space: 55 GB

Download The Game Here


Download Crack For The Game Here




Accounting Basics - Free Online Classes Accounting By Online Courses

Harry



Accounting Basics - Free Online Classes Accounting By Online Courses.

In This Video Series Viewers Will Learn To Prepare And Understand Basic Income Statements, Balance Sheets, And Statements Of Retained Earnings. Here Is An Online Class Accounting With A Serial 40 Online Accounting Lessons For You.


SHARE BY GK
Computer Knowledge

How To Create Logo With DesignEvo | Free Online Logo Creator | Review DesignEvo

Harry



Hello Everyone Welcome To The designevo.com Review


Introduction of DesignEvo

Product Name: DesignEvo

Product Type: Web-based Logo Maker (Now supports desktop software and mobile App)

Founder: Founded by PearlMountain in 2006

Price: 100% Free FREE, $19.99 & $39.99

Best For: Independent Professionals, Small Business Owners, Small Startups, Internet Marketers/Entrepreneurs, Beginners

Have You Seen The Blog Title Of This Post Do You Like It I Created It With designevo.com Yes You Read Right I Created This With Designevo Which Gives You Thousands Of Logo Designs And Fonts Which Gives More Value To Your Brand.


Why Choose DesignEvo ?



1. 4000+ Templates:

Browse Their Different Categories Or Search 4000+ Logo Templates Using Keywords To Find The Logo That Meets Your Needs And Customize It To Make It Your Own.


2) Fonts and Icons:

Millions Of Professionally Designed Icons And 100+ Stylish Fonts Are Available To Take Your Logo To Next Level.


3) Fully Customization:

All Of Their Logos Can Be Fully Customized To Get A Unique Look. Tap Your Creativity And Inner Designer The Possibilities Are Limitless.


4) Free To Use:

Designevo Is Free And Simple To Use. No Download Or Registration Is Required. It Saves Time, Energy And Money.


Check Out Their Different Categories Where You Get 4000+ Logo Templates




1. How To Create Logo with DesignEvo ? ( Text Tutorials )

To Create A Professional Logo With Designevo, All You Need To Do Is To Follow The Following Simple Steps:


Step 1 : Choose a Template



There are 4000+ Professional Templates Arranged Into 34 Categories Including Pchoice Like Pets, Restaurants, Fashion, Technology and Much More.


Step 2 : Add Icons, Shapes and Text



There are Thousand of Icons and Fonts Which Enhance Your Logo.


Step 3 : Customize Your logo



Step 4: Click on The Download Option Which Located in Right Corner Upper Side.




After Click On Downloading You Get This Option If You Don’t Have Sufficient Money Click On Download Free But In Free You Get Low Resolution.

If You Have Money Then Go For Plus Option There You Get High Resolution Logo + PNG With Transparent Background.


2. How To Create Logo with DesignEvo ? ( Video Tutorials )



What Can You Create with DesignEvo



DesignEvo is Recommended By World’s Top Media


Create Stunning Logo Designs Anywhere - DesignEvo For Mobile


DesignEvo For Mobile Apps :-  https://www.designevo.com/for-mobile/

DesignEvo For Desktop :- https://www.designevo.com/for-mobile/