Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Are you crazy to get your dream job and find it difficult to chose between Naukri.com and LinkedIn? Before I give any verdict, let's first have a look at the features of both the platforms:Naukri.comNaukri.com is a mass driven platform. There are recruiters who range from small to large firms but here you find most of the recruiters are from the small units.The profiles of users are not easily comparable.The profiles of users are accessible.The provision of referrals and recommendations does not associate itself to Naukri.comThere is no provision to track an individual, who is actively looking for a job ... Read More
Create a HashMap −HashMap hm = new HashMap();Add elements to the HashMap that we will be displaying afterward −hm.put("Maths", new Integer(98)); hm.put("Science", new Integer(90)); hm.put("English", new Integer(97)); hm.put("Physics", new Integer(91));Now, to display the HashMap elements, use Iterator. The following is an example to display HashMap elements −Example Live Demoimport java.util.*; public class Demo { public static void main(String args[]) { // Create a hash map HashMap hm = new HashMap(); // Put elements to the map ... Read More
Technology Symbolizes the Advancement of Human Knowledge. It is truly a boon. The advantages are many and the list can go on and on and on.They are:Chemotherapy can help cure cancer.It has made the world a global village. Emails, Whatsapp, and other social media have connected people sitting miles away.We can easily communicate sitting anywhere, anytime.One can use the camera to save memories of important events.Food can be cooked faster in Microwave ovens and electric cookers.The mixer grinders help in the easy grinding of food, and juicers help in extracting juice out of fruits and vegetables.Cell phones are certainly the ... Read More
Yes, you can use the LOWER() or LCASE() from MySQL to convert a string to lowercase. Both methods can be used to convert the string into lowercase.Here is the syntax of LOWER() −lower(‘yourStringValue);Or you can use LCASE().The syntax is as follows −lcase(‘yourStringValue);Let us see an example of LOWER(). The query is as follows −mysql> select lower('JOhN');Here is the output −+---------------+ | lower('JOhN') | +---------------+ | john | +---------------+ 1 row in set (0.00 sec)Let us see an example of LCASE(). The query is as follows −mysql> select lcase('JOhN');The following is the ... Read More
Whenever you retrieve datetime from a table, the datetime gives ‘YYYY-MM-DD’ format. If you want to change the output, then you need to use in-built date_format() from MySQL.The syntax is as follows −SELECT DATE_FORMAT(yourDatetimeColumnName, yourFormat) as anyVariableName from yourTableName;To understand the above syntax, let us first create a table. The query to create a table is as follows −mysql> create table UserDateFormat -> ( -> ProductId int, -> ProductDeliverDate datetime -> ); Query OK, 0 rows affected (0.93 sec)Insert some records in the table using insert command. The ... Read More
CDSL stands for Central Depository Services India Ltd and NSDL stands for National Securities Depository Ltd. Depository refers to an organization which holds the stocks of investors and shareholders. NSDL and CDSL are the two apex depositories in India. Just like banks take care of cash and deposits, they hold bonds, stocks etc for the shareholders in electronic form.Functioning of CDSL and NSDLWe need not send share certificates physically for transfers like in the old days, the NSDL and CDSL help to convert and hold shares in the Demat form. Since their establishment, we received huge contributions from both these ... Read More
The NavigableMap pollLastEntry() method remove and returns a key-value mapping associated with the greatest key in this map.Let us first create a NavigableMap and add some elements to it −NavigableMap n = new TreeMap(); n.put(5, "Tom"); n.put(9, "John"); n.put(14, "Jamie"); n.put(1, "Tim"); n.put(4, "Jackie"); n.put(15, "Kurt"); n.put(19, "Tiger"); n.put(24, "Jacob");Now, use the following method −n.pollLastEntry();The following is an example to implement the pollLastEntry() method −Example Live Demoimport java.util.*; public class Demo { public static void main(String[] args) { NavigableMap n = new TreeMap(); n.put(5, "Tom"); n.put(9, "John"); n.put(14, ... Read More
Technology is the application of scientific knowledge for practical purposes, especially in industry. It may be also called as the "advances in computer science.” This technology has actually tamed us. It was thought as a matrix allowing us to connect to the world. But, it has made us the lone ranger.Let Us Look at Some General Terms and FactsNomophobia: The feeling of not having cell phones with you, but still one feels that he carries a phone and this is called Nomophobia. Now, it happens with all of us! We feel that we own a phone every now and then.The ... Read More
Suppose the LIMIT is 4 and OFFSET is 6 then it will return the rows from 7 to 10 i.e. will end with row 10. The LIMIT 4 and OFFSET 6 returns row 7, 8, 9, 10.You can understand the above concept by implementing LIMIT and OFFSET. Let us create a table.mysql> create table LimitOffsettable -> ( -> Id int -> ); Query OK, 0 rows affected (0.60 sec)Let us insert some records in the table. The query is as follows −Mysql> insert into LimitOffsettable values(1); Query OK, 1 row affected ... Read More
In MySQL, there is no way to truncate with condition. You cannot use truncate statement with where clause.If you want the condition, use delete command −DELETE FROM yourTableName WHERE youCondition;The above syntax is fine but if you want a faster solution, then DELETE is not good in comparison to Truncate. The advantage with truncate is that it does not write to the logs.Let us create a table. The query to create a table is as follows −mysql> create table DeleteDemo -> ( -> Id int, -> Name varchar(100) ... Read More