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 ...
Use recursion
Check for negative and zero before calling recursion and make changes in the result array accordingly.
- accessdenied July 10, 2015