Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
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
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
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
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
Digital Marketing is the present day career on a boom. It is a way of advertising that provides many ways of online platforms for your product or service, unlike the traditional ways of advertising.To get established yourself as a digital marketing expert, it is always better to get certified. Google AdWords Certification and HubSpot Inbound Certification are the ones which are available for free. You can even try applying them again if you fail to succeed in your initial attempts.Preparing for the HubSpot Inbound Certification enables you to optimize your website and content, helps in making customers as brand promoters ... Read More
You can use SELECT IF statement with OR. To understand select with OR, let us create a table. The query to create a table is as follows −mysql> create table EmployeeInformation -> ( -> EmployeeId int, -> EmployeeName varchar(100), -> EmployeeStatus varchar(100) -> ); Query OK, 0 rows affected (0.68 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into EmployeeInformation values(1, 'Sam', 'FullTime'); Query OK, 1 row affected (0.23 sec) mysql> insert into EmployeeInformation values(2, 'Mike', 'PartTime'); Query OK, 1 row affected (0.14 sec) mysql> ... Read More
In this program we will see how to search an element in an array of bytes using 8085.Problem StatementWrite 8085 Assembly language program to search a key value in an array of data using linear search technique.DiscussionIn this program the data are stored at location 8002H to 8007H. The 8000H is containing the size of the block, and 8001H is holding the key value to search. After executing this program, it will return the address of the data where the item is found and store the address at location 9000H and9001H. If the item is not found, it will return ... Read More