Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Nitin Sharma
Page 3 of 3
Difference between Where and Having
Both Where and Having are the two keywords used in SQL query to filter and summarize the data that is retrieved from database based on given condition.On the basis of features of both keywords we can distinguish between Where and Having as follows −Sr. No.KeyWhereHaving1DefinitionWHERE clause in SQL query specifies search conditions for the rows returned by the it and limits rows to a specific row-set. In case if user wants to get the particular records based on some specific classification or condition then using ‘where’ clause is useful.The WHERE clause is used to specify the required condition (on aggregate ...
Read MoreDifference between print() and println() in Java
As we know in Java these both methods are primarily used to display text from code to console. Both these methods are of PrintStream class and are called on static member 'out' of 'System' class which is a final type class.The following are the important differences between print() and println().Sr. No.Keyprint()println()1Implementationprint method is implemented as it prints the text on the console and the cursor remains at the end of the text at the console.On the other hand, println method is implemented as prints the text on the console and the cursor remains at the start of the next line ...
Read MoreWhat is the difference between ODBC and JDBC
Both ODBC and JDBC are the programming interface that is required by the applications at the client side to access the database at server side. Basically both are known as drivers to get connected with a database and are provided by the vendors of RDBMS.The following are the important differences between ODBC and JDBC.Sr. No.KeyODBCJDBC1Stands ForODBC stands for Open Database Connectivity which literally means that it is compatible with all types of languages such as C, C++, Java, etc.JDBC Stands for Java database connectivity i.e only compatible with java language.2IntroductionODBC was introduced by Microsoft prior to JDBC in 1992.JDBC was ...
Read MoreDifference between length of Array and size of ArrayList in Java
In collections, one of the main functional requirement is to get the number of elements which are get stored in our collection so that one can decide whether to put more elements in it or not. Also, the number of elements is also required for iteration of collection.As we know Array and Arraylist both are used to store elements but both have different defined methods in order to know the number of elements stored in it.The array has a length method that provides the number of elements can be stored or in simple words capacity of the Array. Also, the ...
Read MoreDifference between Bootstrap and AngularJS.
Along with many other frameworks for front end development AngularJs and Bootstrap are two well-known frameworks in the market.AngularJS is widely used for single page application development as it provides MVC architecture with data model binding. On the other hand, Bootstrap uses HTML, CSS, and JavaScript for its development which makes it comparatively faster.The following are the important differences between Bootstrap and AngularJS.Sr. No.KeyAngularJSBootstrap1Basic DifferenceAngularJs was developed by Google and primarily uses a component concept which makes its developed application more structural.Bootstrap was introduced by Twitter as part of the open-source community with very common libraries such as CSS, Styles, ...
Read MoreDifference between Arrays and Collection in Java
In order to store multiple values or objects of the same type, Java provides two types of data structures namely Array and Collection.The following are the important differences between Arrays and Collection.Sr. No.KeyArraysCollection1SizeArrays are fixed in size i.e once the array with the specific size is declared then we can't alter its size afterward.The collection is dynamic in size i.e based on requirement size could be get altered even after its declaration.2Memory ConsumptionArrays due to fast execution consumes more memory and has better performance.Collections, on the other hand, consume less memory but also have low performance as compared to Arrays.3Data ...
Read More