Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
To get the users logged in today, use the below syntax. Here, we are expecting that your datetime field is a string type −select yourColumnName1, yourColumnName2, yourColumnName3, ...N from youTableName WHERE STR_TO_DATE(yourColumnName1, ‘format’') =CURDATE();Let’s say we have the following “DateEqualToday “ table that stores users first and last name with the login date −+------+------------+-----------+------------+ | Id | First_Name | Last_Name | LoginDate | +------+------------+-----------+------------+ | 1 | James | Smith | 20-12-2018 | | 2 | Carol | Taylor | 21-12-2017 | | 3 | John ... Read More
You can sort a column, with 0 come last with the help of ORDER BY. The syntax is as follows −select *from yourTableName order by yourFieldName = 0, yourFieldName;To understand the above concept, let us create a table. The query to create a table is as follows −mysql> create table SortColumnZeroAtLastDemo −> ( −> RankNumber int −> ); Query OK, 0 rows affected (1.40 sec)Now you can insert records in the table using the following query −mysql> insert into SortColumnZeroAtLastDemo values(100); Query OK, 1 row affected (0.20 sec) mysql> insert into SortColumnZeroAtLastDemo values(0); Query OK, 1 ... Read More
The sub-list of an ArrayList can be obtained using the java.util.ArrayList.subList() method. This method takes two parameters i.e. the start index for the sub-list(inclusive) and the end index for the sub-list(exclusive) from the required ArrayList. If the start index and the end index are the same, then an empty sub-list is returned.A program that demonstrates this is given as followsExample Live Demoimport java.util.ArrayList; import java.util.List; public class Demo { public static void main(String[] args) { ArrayList aList = new ArrayList(); aList.add("Apple"); ... Read More
In this program we will see how to swap two numbers.Problem StatementWrite 8085 Assembly language program to swap two 8-bit number stored at location 8000Hand 8001H.DiscussionIn 8085, there is an instruction XCHG. Using this we can swap the contents of DE and HL values. We are taking the numbers and storing them into H and D, then using XCHG the contents are swapped.InputAddressData......8000CD800134......Flow DiagramProgramAddressHEX CodesMnemonicsCommentsF0003A, 00, 80LDA 8000HLoad the first number into AF00367MOV H, AStore the number into HF0043A, 01, 80LDA 8001HLoad the second number into AF00757MOV D, AStore the number into DF008EBXCHGExchange DE and HLF0097CMOV A, HTake H content ... Read More
To request location services permission in ios with swift we can use the CLLocationManager.We’ll do this with help of a sample project. So, create a new project. First, we need to create a locationManager object, so in your view controller.var locationManager = CLLocationManager()Now, we, first of all, we need to check if the location services are enabled on the device or not. To check this we’ll useCLLocationManager.locationServicesEnabled() function, which returns a Boolean value showing whether the location service on the device is active or not.if CLLocationManager.locationServicesEnabled() { print("permissions allowed") } else { locationManager.requestAlwaysAuthorization() locationManager.requestWhenInUseAuthorization() }In the example ... Read More
It is said that “Secrets tend to get revealed when one is feeling most loved or one is feeling most betrayed.” Well, in my case neither love nor betrayal has overpowered me. Still, there are certain feelings and certain emotions too, which come up somewhere somehow through the facial expressions or the body language.Revealing A SecretSo, the one secret that I wish to reveal is my realization of, “Secrets should be kept secret.” Because if they are revealed to the right person, only then they hold their worth like a currency note in the hands of a spendthrift is merely ... Read More
To vertically align numeric values in Java, use Formatter. For working with Formatter class, import the following package.import java.util.Formatter;Take an array −double arr[] = { 2.5, 4.8, 5.7, 6.5, 9.4, 8.4, 9.5, 10.2, 11.5 };While displaying this double array values, use the %f to set spaces −for (double d : arr) { f.format("%12.2f %12.2f %12.2f", d, Math.ceil(d), Math.floor(d)); }Above, we have also set the decimal places i.e. 12.2f is for 2 decimal places.The following is an example −Example Live Demoimport java.util.Formatter; public class Demo { public static void main(String[] argv) throws Exception { ... Read More
Linguistics is an important part of preserving traditional knowledge and help in preserving regional diversity. Learning a new language is exciting and challenging. A new language helps in understanding the stories and traditions that exist with local people. Hence, many people are always keen on learning new languages. There are bound to be ambiguities and disconnections while learning a new language. It is important to keep perseverance and patience in grasping the new elements of the language. Here are some tips which help to start learning a new language:Use TranslationWhenever you are learning a new language, it is also important ... Read More
Referring to Carlyle, Hugh Walker observed, “ Carlyle’ histories are, like his other works, intensely personal and also intensely practical.”In The Hero as Divinity, he picturizes beautifully Igdrasil, the Ash tree of existence, and with a sigh contrasts with it the machine theory of the universe.Carlyle’s Political PhilosophyCarlyle was the greatest critic of political ideas prevailing in his own day. His political ideas changed in the course of time. During his young age, he was radical and believer in Democracy, but as he grew older, he became more conservative.Carlyle’s ReligionHe was a deeply religious man with implicit faith in God. ... Read More
In this program we will see how to swap two numbers in direct addressing mode.Problem StatementWrite 8085 Assembly language program to swap two 8-bit number stored at location 8000H and 8001H using direct addressing mode. DiscussionIn this case we are taking the number from memory by using the HL pair. The HL pair is storing the address of the data item. We are taking the first number into B register, and the second number to A register, then storing the content of B to the next position, and storing the value of A into first position.InputAddressData......8000CD800134......Flow DiagramProgramAddressHEX CodesMnemonicsCommentsF00021, 00, 80LXI H, ... Read More
To Continue Learning Please Login