mayank-sqltricks.blogspot.com

sql tricks

Thursday, June 16, 2011. Lets play with decode. Suppose that we have a task we have to find the details of employees who have job id 'CLARK', 'MANAGER', 'PROGRAMMER'. So what we usually do is we write in where clause something like this. Where job id in ('CLARK', 'MANAGER', 'PROGRAMMER');. But we can also do this using decode function. like. Where decode(job id, 'CLARK',1,'MANAGER',1,'PROGRAMMER',1,0) = 1;. KEEP READING MY BLOGS. Department wise Nth Highest salary from a table. Emp no dept no salary.

http://mayank-sqltricks.blogspot.com/

OVERVIEW OF mayank-sqltricks.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

4

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR MAYANK-SQLTRICKS.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

November

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.7 out of 5 with 13 reviews

5 star

6

4 star

1

3 star

4

2 star

0

1 star

2

Hey there! Start your review of mayank-sqltricks.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT MAYANK-SQLTRICKS.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

4

SSL

EXTERNAL LINKS

0

SITE IP

172.217.3.97

LOAD TIME

0.585 sec

SCORE

6.2

PAGE TITLE

sql tricks | mayank-sqltricks.blogspot.com Reviews

<META> DESCRIPTION

Thursday, June 16, 2011. Lets play with decode. Suppose that we have a task we have to find the details of employees who have job id 'CLARK', 'MANAGER', 'PROGRAMMER'. So what we usually do is we write in where clause something like this. Where job id in ('CLARK', 'MANAGER', 'PROGRAMMER');. But we can also do this using decode function. like. Where decode(job id, 'CLARK',1,'MANAGER',1,'PROGRAMMER',1,0) = 1;. KEEP READING MY BLOGS. Department wise Nth Highest salary from a table. Emp no dept no salary.

<META> KEYWORDS

1 sql tricks

2 posted by

3 mayank

4 no comments

5 email this

6 blogthis

7 share to twitter

8 share to facebook

9 share to pinterest

10 table employees

CONTENT

Page content here

KEYWORDS ON PAGE

sql tricks,posted by,mayank,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,table employees,6 comments,1 comment,labels sql,followers,blog archive,about me

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

sql tricks | mayank-sqltricks.blogspot.com Reviews

https://mayank-sqltricks.blogspot.com

Thursday, June 16, 2011. Lets play with decode. Suppose that we have a task we have to find the details of employees who have job id 'CLARK', 'MANAGER', 'PROGRAMMER'. So what we usually do is we write in where clause something like this. Where job id in ('CLARK', 'MANAGER', 'PROGRAMMER');. But we can also do this using decode function. like. Where decode(job id, 'CLARK',1,'MANAGER',1,'PROGRAMMER',1,0) = 1;. KEEP READING MY BLOGS. Department wise Nth Highest salary from a table. Emp no dept no salary.

INTERNAL PAGES

mayank-sqltricks.blogspot.com

1

sql tricks: Department wise Nth Highest salary from a table

http://mayank-sqltricks.blogspot.com/2011/06/department-wise-nth-highest-salary-from.html

Thursday, June 16, 2011. Department wise Nth Highest salary from a table. Hello again hope you enjoyed my last blog. Here i am going to tell you something more complex.suppose we have a table named employees. Emp no dept no salary. And now what you want is -. Dept no 2nd high salary. So the query will be-. Select dept no, salary, dense rank() over(partition by dept no order by salary desc ) den rank from employees where rank = &n;. August 28, 2011 at 11:45 PM. January 3, 2015 at 1:53 AM.

2

sql tricks: Lets play with decode

http://mayank-sqltricks.blogspot.com/2011/06/lets-play-with-decode.html

Thursday, June 16, 2011. Lets play with decode. Suppose that we have a task we have to find the details of employees who have job id 'CLARK', 'MANAGER', 'PROGRAMMER'. So what we usually do is we write in where clause something like this. Where job id in ('CLARK', 'MANAGER', 'PROGRAMMER');. But we can also do this using decode function. like. Where decode(job id, 'CLARK',1,'MANAGER',1,'PROGRAMMER',1,0) = 1;. KEEP READING MY BLOGS. Subscribe to: Post Comments (Atom). Lets play with decode.

3

sql tricks: Nth Highest salary from a table

http://mayank-sqltricks.blogspot.com/2011/06/nth-highest-salary-from-table.html

Thursday, June 16, 2011. Nth Highest salary from a table. Hello everybody, How r u? Hope u all are rocking here i m giving you some useful tricks that will help you in your work or in cracking a interview. Suppose you have to find out nth highest salary of an employee from a table employees then you have three ways to solve this problem. 1 SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal) FROM EMP B. WHERE a.sal =b.sal);. 3 And the last and simplest method of doing this is-.

4

sql tricks: June 2011

http://mayank-sqltricks.blogspot.com/2011_06_01_archive.html

Thursday, June 16, 2011. Lets play with decode. Suppose that we have a task we have to find the details of employees who have job id 'CLARK', 'MANAGER', 'PROGRAMMER'. So what we usually do is we write in where clause something like this. Where job id in ('CLARK', 'MANAGER', 'PROGRAMMER');. But we can also do this using decode function. like. Where decode(job id, 'CLARK',1,'MANAGER',1,'PROGRAMMER',1,0) = 1;. KEEP READING MY BLOGS. Department wise Nth Highest salary from a table. Emp no dept no salary.

UPGRADE TO PREMIUM TO VIEW 0 MORE

TOTAL PAGES IN THIS WEBSITE

4

OTHER SITES

mayank-nagar.blogspot.com

Reality Check

Friday, October 3, 2014. Thursday, April 10, 2014. Century, which got freedom some 60 years back but still chooses its representatives in parliament based on caste and religion. Now an important point is why we behave like this? Why don’t we question their expenses and the money spent on the luxuries and unnecessary foreign tours? I am sure no one remembers, the Karnataka MLAs foreign trip or the star studded festival in UP while people died in muzaffarnagar camps). Monday, December 12, 2011. Just recall...

mayank-parentingtips.blogspot.com

Parenting Tips

Monday, May 16, 2011. Fancy Dress Ideas for Kids. Read some interesting fancy dress ideas for Indian kids and also fancy dress for other kids. You will find a list of characters you can dress up your child as. Read about how to dress up a child for a fancy dress competition. Go through this list of fancy dress ideas and get your child all dressed up fancifully. Fancy Dress competition preparation:. In fact, children must be encouraged to participate in fancy dress competitions so that they get confidence...

mayank-sanghvi.blogspot.com

Mayank Sanghvi

Subscribe to: Posts (Atom). View my complete profile. Awesome Inc. theme. Powered by Blogger.

mayank-shekhar.com

Mayank Shekhar

FrontEnd Developer, Gurgaon.

mayank-singh.deviantart.com

Mayank-Singh (Mayank Singh) - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Digital Art / Student. Deviant for 6 Years. Last Visit: 23 weeks ago. This deviant's activity is hidden. Deviant since Oct 18, 2010. Artist Stu...

mayank-sqltricks.blogspot.com

sql tricks

Thursday, June 16, 2011. Lets play with decode. Suppose that we have a task we have to find the details of employees who have job id 'CLARK', 'MANAGER', 'PROGRAMMER'. So what we usually do is we write in where clause something like this. Where job id in ('CLARK', 'MANAGER', 'PROGRAMMER');. But we can also do this using decode function. like. Where decode(job id, 'CLARK',1,'MANAGER',1,'PROGRAMMER',1,0) = 1;. KEEP READING MY BLOGS. Department wise Nth Highest salary from a table. Emp no dept no salary.

mayank-talwar.blogspot.com

Hey

Monday, August 16, 2010. Hi friends ,. I am Mayank Talwar . I am born and brought up in India and presently living in canada. I found there are lots of young people who wants to study in Canada but they are lacking for information about that country ,colleges and other info . I am putting my step forward to help them . so if you have any question or any help regarding study in canada you can e-mail me on Info4study.abroad@gmail.com. Subscribe to: Posts (Atom). View my complete profile.

mayank-webs.co.nr

Mayank Web Solutions

Webdesign, web design, webtemplate, web template, mayank, mayank kushwaha, m4yank, m4yank@yahoo.com, mack, web design studio, webdesign studio, mayank webdesign studio, mayank kushwaha webdesign studio, mayank kushwaha web design studio, mack webdesign st. To visit Mayank Web Solutions.

mayank.biz

Welcome

mayank.co.in

Mayank Srivastava

mayank.co.nr

Mayank Abhishek

To visit Mayank Abhishek.