Thursday, March 12, 2020

How to get random rows in SQL? SQL Query to get Random data. Top N Random Records.

There are a number of ways to get Random data from database. Following are some examples that works without any extra algorithm:

SQL Server:

SELECT TOP 20 *
FROM table_name
ORDER BY NEWID()

MySQL:

SELECT *
FROM table_name
ORDER BY RAND()
LIMIT 20



PostgreSQL:

SELECT *
FROM table_name
ORDER BY RANDOM()
LIMIT 20

Oracle:

SELECT *  FROM
( SELECT *
FROM table_name
ORDER BY dbms_random.value )
WHERE rownum <= 20











Thursday, March 5, 2020

Indonesia Public Holidays 2020


  Indonesia Public Holidays 2020

Following table contains a national calendar of all 2020 public holidays for Indonesia which is subject to change on official decision by the government of Indonesia.

DateDayHoliday
1 JanuaryWednesdayNew Year's Day
25 JanuarySaturdayChinese New Year
22 MarchSundayIsra Mi'raj
25 MarchWednesdayBali Hindu New Year
10 AprilFridayGood Friday
1 MayFridayLabour Day
7 MayThursdayWaisak Day
21 MayThursdayAscension Day of Jesus Christ
22 MayFridayLebaran Holiday
24 May to 25 MaySunday to MondayHari Raya Idul Fitri
26 May to 27 MayTuesday to WednesdayLebaran Holiday
1 JuneMondayPancasila Day
31 JulyFridayIdul Adha
17 AuguestMondayIndependence Day
20 AuguestThursdayIslamic New Year
29 OctoberThursdayProphet Muhammad's Birthday
24 DecemberThursdayChristmas Holiday
25 DecemberFridayChristmas Day


Wednesday, March 4, 2020

Thailand Public Holidays 2020

  Thailand Public Holidays 2020

Following table contains a national calendar of all 2020 public holidays for Thailand which is subject to change on official decision by the government of Thailand.

Date Day Holiday
1 January Wednesday New Year's Day
25 January Saturday Chinese New Year
8 FebruarySaturdayMakha Bucha Day
10 FebruaryMondayMakha Bucha Holiday
6 AprilMondayChakri Day
13 April to 16 AprilMonday to ThursdaySongkran Festival
1 MayFridayLabour Day
4 MayMondayCoronation of King Vajiralongkorn
6 MayWednesdayVisakha Bucha Day
11 MayMondayRoyal Ploughing Ceremony
24 MaySundayEnd of Ramadan
3 JuneWednesdayQueen Suthida's Birthday
5 JulySundayAsahna Bucha Day
6 JulyMondayKhao Phansa Day
6 JulyMondayAsahna Bucha Day Holiday
7 JulyTuesdayKhao Phansa Holiday
28 JulyTuesdayKing Vajiralongkorn's Birthday
12 AugustWednesdayHer Majesty the Queen Mother's Birthday
13 OctoberTuesdayPassing of His Majesty the Late King
23 OctoberFridayChulalongkorn Memorial Day
5 DecemberSaturdayHis Majesty the Late King's Birthday
7 DecemberMondayHis Majesty the Late King's Birthday Holiday
10 DecemberThursdayConstitution Day
25 DecemberFridayChristmas Day
31 December Thursday New Year's Eve


Google Sheet Tutorial Basic Mathematical Functions & Formulas





Google Sheet Tutorial Basic Mathematical Functions and Formulas. Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people. With Google Sheets, everyone can work together in the same spreadsheet at the same time. Use formulas, functions, and formatting options to save time and simplify common spreadsheet tasks. Google sheet is alternative to Microsoft Excel and have some facilities over Microsoft excel.


Referral links that will not charge you but help me earning commissions. Buy tubebuddy channel booster plugin for your channel: https://bit.ly/2HP5lJR

Please watch till the end of the video, I hope you will enjoy it. If you have enjoy the video, please go ahead and like it. Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments. Please join in our community through subscription of channel and subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v



Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v

Channel URL: https://goo.gl/VYi58K

Most Recent Videos: https://goo.gl/hXFN4w

Most Popular Video: https://goo.gl/7u7B1x


Social:

Facebook: https://www.facebook.com/triksbuddy/

Linked in: https://www.linkedin.com/company/triksbuddy/

Blog: https://triksbuddy.blogspot.com/

Tumblr: https://imrulquaes89.tumblr.com/

RSS Feed:
https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw



 #GoogleSheetTutorial, #triksbuddy

How to Draw Usecase Diagram using Draw.io







Learn How to Draw Usecase Diagram using Draw.io. This video shows you how easily you can draw usecase uml diagram using www.Draw.io. 

Use cases are a way of describing interactions between users and a system using a graphical model and structured text. They were first introduced in the Objectory method and have now become a fundamental feature of the Unified Modeling Language (UML). In their simplest form, a use case identifies the actors involved in an interaction and names the type of interaction. You then add additional information describing the interaction with the system. The additional information may be a textual description or one or more graphical models such as the UML sequence or state charts.

Use cases identify the individual interactions between the system and its users or other systems. Each use case should be documented with a textual description. These can then be linked to other models in the UML that will develop the scenario in more detail.

There are many tools available in the market for drawing use case diagrams. Visio is one of the most popular tool from microsoft which is not free for use. As an alternative of visio, draw.io is a great tool that allows you free access along with free storage and integration with other cloud applications like google drive, dropbox etc for storing you drawings.

 
 
If you have enjoy the video and get it interesting, please hit like button.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification. 
 
In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. 
Subscription link: https://goo.gl/GE4g8v 
Please subscribe in below link and like our video. 
Subscription URL: https://goo.gl/GE4g8v 
Channel URL: https://goo.gl/VYi58K 
Most Recent Videos: https://goo.gl/hXFN4w 
Most Popular Video: https://goo.gl/7u7B1x 
Social:
Facebook: https://www.facebook.com/triksbuddy/ 
Linked in: https://www.linkedin.com/company/triksbuddy/ 
Blog: https://triksbuddy.blogspot.com/ 
Tumblr: https://www.tumblr.com/blog/imrulquaes89 
RSS Feed: https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw
 

Creating a Meeting in GSuite Google Calender - triksbuddy







This video will shows way of creating a meeting in GSuite Google
Calender. Google GSuite allows you to create a meeting call easily using
google calender. The application allows you to setup meeting
notification which will be shown to the participants before the given
period of time before the meeting. GSuite allows you to setup available
meeting rooms of your organization. You can invite internal and external
guest.