accessdenied
BAN USER
- 11
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)
Open Chat in New Window
Use recursion
char result [50]; int i=0; void itoa(int a){ if(!a) return; else itoa(a/10); result [i++]= a%10+'0'; }Check for negative and zero before calling recursion and make changes in the result array accordingly.
- accessdenied July 10, 2015