accessdenied
BAN USER
- 0of 0 votes
AnswersI 've table book containing 2 columns
- accessdenied in India
title and price
there are a number of books there with different prices
what is result of the following query
select title from book as b where (select count(*) from book as t where t.price>b.price) < 5| Report Duplicate | Flag | PURGE
SQL
1 Answer What is the output of this SQL query?
I 've table book containg 2 columns
- accessdenied January 14, 2013
title and price
there are a number of books there with different prices
what is result of the following query
select title from book as b where (select count(*) from book as t where t.price>b.price) < 5| Flag | PURGE
Yes, the answer is : it will select 5 most expensive books.
But how the query is running i m confused. Can anyone explain
c=0 is wrong... I sorry actually i forgot to multiply before...
15 is correct..
i checked it
how come...same approaches at same time.. :)
- accessdenied September 12, 2012I don't know my approach is efficient..but it is an approach..so tell me
take 3 vars count_0, count_1, count_2
traverse the list once to get each total count numbers
traverse the list and change the values simply...
i know it's a bit funny approach...nothing sorting or swapping..so tell me a better one
But it's O(n)
Repjoyjerraj, Android test engineer at ASAPInfosystemsPvtLtd
I am a sales manager .I'm responsible for leading and coaching a team of salespeople. A sales manager's ...
Repjuliaaperez05, Cloud Support Associate at ABC TECH SUPPORT
I Performed extensive web research to collect pertinent data and gather images related to the assigned articleIts act of writing ...
Repsalinagray, Development Support Engineer at Atmel
Hi I am Salina Gray,I live in Texas and work as a Design Team Member. I am new to ...
Repclarasbarr, Korean Air Change Flight at Adap.tv
I am ClaraBarr from California USA. Writes and records various different genres for television, film and other artists.Wrote several ...
Repcarlotamdaniel, abc at ADP
Repluisbshifflett, Aghori Mahakal Tantrik at ABC TECH SUPPORT
I am working as a partner in the Project Planner.I additionally assists people groups with holding appearance rights or ...
RepShirleyMHansen, Project Leader at Chelsio Communications
I am Physical Therapy Aide with 3 years experience in hospital. I like to build up my knowledge of various ...
Rephinescarol45, +27655765355 SSD MONEY CLEANING CHEMICAL +27655765355 BLACK MONEY IN JOHANNESBURG, OMAN, SAUDI ARABIA, SUDAN, Somalia ,Zimbabwe Botswana at 247quickbookshelp
I am Carol From San Diego USA, I am Working as a Personal assistant in a Castle Realty organization, I ...
Repritahmixon, Analyst at ADP
Hi, I am a physiotherapy to help people handle everyday problems. I also assist peoples who have issues caused by ...
Open Chat in New Window
Use recursion
Check for negative and zero before calling recursion and make changes in the result array accordingly.
- accessdenied July 10, 2015