#4.4 Using Query Parameters in Retrofit to Fetch Data: Android Retrofit using Kotlin

Access 7000+ courses for 60 days FREE: https://pluralsight.pxf.io/c/1291657/424552/7490

Android Kotlin Tutorial. Explore what is Query parameters in retrofit and how to use it to fetch data from web service using @Query retrofit annotation.

Next Video: https://youtu.be/Bkz4rxgMROA
Previous Video: https://youtu.be/qiaX760_-VQ

Video Source Code: https://bit.ly/2zVLQJe
Full Course Code: https://bit.ly/2FMVnHD
Run Node Web Service: https://youtu.be/XU-rlStKBAY

Check out my website:
https://bit.ly/smartherd

Donate and support us
[Only if you think our courses are better than Udemy or Udacity]
➤ Patreon: https://bit.ly/patreon-donate
➤ Paypal/Payoneer: sriyank123@gmail.com
➤ UPI (only for India): smartherd@okaxis

Programming courses:
➤ Ruby Programming: https://bit.ly/smyt-r
➤ Dart Programming: https://bit.ly/smyt-d
➤ Kotlin Programming: https://bit.ly/smyt-k
➤ Java Programming: https://bit.ly/smyt-j

Flutter course:
➤ Flutter App Development: https://bit.ly/2Rg7EFR

Android courses:
➤ Android using Kotlin: https://bit.ly/smyt-ka
➤ Android using Java: https://bit.ly/smyt-ja
➤ Android Material Design: https://bit.ly/2SMJqU6
➤ Android Jetpack Architecture: https://bit.ly/yt-j
➤ Android Multiple Screen Support: https://bit.ly/smyt-mss
➤ Android Retrofit: https://bit.ly/2Ee6GHn

More programming courses:
https://bit.ly/smy-list

Follow us on
Facebook: https://bit.ly/smartherd-facebook
Twitter: https://bit.ly/smartherd-twitter
Github: https://bit.ly/smartherd-github

—- Thank you for your love and support —-

#2 Kotlin Hello World: Write your first code in Kotlin and Run it in INTELLIJ IDEA

Access 7000+ courses for 15 days FREE: https://pluralsight.pxf.io/c/1291657/431340/7490

Kotlin Android Beginner Tutorial: How to write code in Kotlin and run it in Intellij IDEA. Kotlin is now official Android Language as declared in Google I/O. Say bye bye to Java and say Hello World in Kotlin.

Source code files : https://bit.ly/2QtcUWR

Next Video : https://youtu.be/MM1jRsXiWBg
Previous Video : https://youtu.be/QUI0PopN1nw

Check out my website:
https://bit.ly/smartherd

Donate and support us
[Only if you think our courses are better than Udemy or Udacity]
➤ Patreon: https://bit.ly/patreon-donate
➤ Paypal/Payoneer: sriyank123@gmail.com
➤ UPI (only for India): smartherd@okaxis

Programming courses:
➤ Ruby Programming: https://bit.ly/smyt-r
➤ Dart Programming: https://bit.ly/smyt-d
➤ Kotlin Programming: https://bit.ly/smyt-k
➤ Java Programming: https://bit.ly/smyt-j

Flutter course:
➤ Flutter App Development: https://bit.ly/2Rg7EFR

Android courses:
➤ Android using Kotlin: https://bit.ly/smyt-ka
➤ Android using Java: https://bit.ly/smyt-ja
➤ Android Material Design: https://bit.ly/2SMJqU6
➤ Android Jetpack Architecture: https://bit.ly/yt-j
➤ Android Multiple Screen Support: https://bit.ly/smyt-mss
➤ Android Retrofit: https://bit.ly/2Ee6GHn

More programming courses:
https://bit.ly/smy-list

Follow us on
Facebook: https://bit.ly/smartherd-facebook
Twitter: https://bit.ly/smartherd-twitter
Github: https://bit.ly/smartherd-github

—- Thank you for your love and support —-

Channel: Smartherd
Published: 2017-05-18 16:45:07
Duration: 10M3S
Views: 42798
Likes: 291
Favorites: 0

#4.2 Kotlin Data Types: VAR vs VAL: Variables and Constants Part-1

Access 7000+ courses for 15 days FREE: https://pluralsight.pxf.io/c/1291657/431340/7490

Kotlin Android Tutorial. Lets learn about Variables and Constants and various data types defined in Kotlin. In kotlin we have everything as objects. String, Integer, Float etc all are objects. There is no primitive data types in Kotlin.

Source code files : https://bit.ly/2QtcUWR

Next Video : https://youtu.be/SItGASY92HE
Previous Video : https://youtu.be/r-IEGuDD2rU

Check out my website:
https://bit.ly/smartherd

Donate and support us
[Only if you think our courses are better than Udemy or Udacity]
➤ Patreon: https://bit.ly/patreon-donate
➤ Paypal/Payoneer: sriyank123@gmail.com
➤ UPI (only for India): smartherd@okaxis

Programming courses:
➤ Ruby Programming: https://bit.ly/smyt-r
➤ Dart Programming: https://bit.ly/smyt-d
➤ Kotlin Programming: https://bit.ly/smyt-k
➤ Java Programming: https://bit.ly/smyt-j

Flutter course:
➤ Flutter App Development: https://bit.ly/2Rg7EFR

Android courses:
➤ Android using Kotlin: https://bit.ly/smyt-ka
➤ Android using Java: https://bit.ly/smyt-ja
➤ Android Material Design: https://bit.ly/2SMJqU6
➤ Android Jetpack Architecture: https://bit.ly/yt-j
➤ Android Multiple Screen Support: https://bit.ly/smyt-mss
➤ Android Retrofit: https://bit.ly/2Ee6GHn

More programming courses:
https://bit.ly/smy-list

Follow us on
Facebook: https://bit.ly/smartherd-facebook
Twitter: https://bit.ly/smartherd-twitter
Github: https://bit.ly/smartherd-github

—- Thank you for your love and support —-

Channel: Smartherd
Published: 2017-05-20 10:52:33
Duration: 6M16S
Views: 9969
Likes: 63
Favorites: 0

MS Excel – Import Live Data From Web

MS Excel – Import Live Data From Web
Watch More Videos at:
https://www.tutorialspoint.com/videotutorials/index.htm
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Channel: Tutorials Point (India) Pvt. Ltd.
Published: 2018-01-15 09:13:38
Duration: 9M21S
Views: 142675
Likes: 1866
Favorites: 0

Part 1 How to find nth highest salary in sql

Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists

Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html

This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary.

By the end of this video, we will be able to answer all the following questions as well.
How to find nth highest salary in SQL Server using a Sub-Query
How to find nth highest salary in SQL Server using a CTE
How to find the 2nd, 3rd or 15th highest salary

Let’s use the following Employees table for this demo

Use the following script to create Employees table
Create table Employees
(
ID int primary key identity,
FirstName nvarchar(50),
LastName nvarchar(50),
Gender nvarchar(50),
Salary int
)
GO

Insert into Employees values (‘Ben’, ‘Hoskins’, ‘Male’, 70000)
Insert into Employees values (‘Mark’, ‘Hastings’, ‘Male’, 60000)
Insert into Employees values (‘Steve’, ‘Pound’, ‘Male’, 45000)
Insert into Employees values (‘Ben’, ‘Hoskins’, ‘Male’, 70000)
Insert into Employees values (‘Philip’, ‘Hastings’, ‘Male’, 45000)
Insert into Employees values (‘Mary’, ‘Lambeth’, ‘Female’, 30000)
Insert into Employees values (‘Valarie’, ‘Vikings’, ‘Female’, 35000)
Insert into Employees values (‘John’, ‘Stanmore’, ‘Male’, 80000)
GO

To find the highest salary it is straight forward. We can simply use the Max() function as shown below.
Select Max(Salary) from Employees

To get the second highest salary use a sub query along with Max() function as shown below.
Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees)

To find nth highest salary using Sub-Query
SELECT TOP 1 SALARY
FROM (
SELECT DISTINCT TOP N SALARY
FROM EMPLOYEES
ORDER BY SALARY DESC
) RESULT
ORDER BY SALARY

To find nth highest salary using CTE
WITH RESULT AS
(
SELECT SALARY,
DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK
FROM EMPLOYEES
)
SELECT TOP 1 SALARY
FROM RESULT
WHERE DENSERANK = N

To find 2nd highest salary we can use any of the above queries. Simple replace N with 2.

Similarly, to find 3rd highest salary, simple replace N with 3.

Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates.
WITH RESULT AS
(
SELECT SALARY,
ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER
FROM EMPLOYEES
)
SELECT SALARY
FROM RESULT
WHERE ROWNUMBER = 3

Channel: kudvenkat
Published: 2014-05-17 21:10:02
Duration: 11M45S
Views: 861522
Likes: 3443
Favorites: 0

Leave a Reply

Your email address will not be published. Required fields are marked *