[Show all top banners]

cp21
Replies to this thread:

More by cp21
What people are reading
Subscribers
:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 need statement without FROM clause
[VIEWED 9287 TIMES]
SAVE! for ease of future access.
Posted on 11-11-15 9:23 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Write a SELECT statement without a FROM clause that creates a row with these columns:
Price 100 (dollars)
TaxRate .07 (7 percent)
TaxAmount The price multiplied by the tax
Total The price plus tax
To calculate the fourth column, add the expressions you used for the first and third columns
 
Posted on 11-12-15 2:20 AM     [Snapshot: 75]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 
 
Posted on 11-14-15 7:38 AM     [Snapshot: 216]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

मेरो भान्जा पुल्चौक क्याम्पस बाट कम्पुटर साईन्स सिध्याएर अमेरिका छिरेको : ५ बर्ष पछि MS डिग्री मा जोइन गरेको प्रोग्रामिङ्गमा कम्जोर भएर पहिलो सेमेस्टर मै ड्रप गर्यो |
अमेरिका बस्नु छ र हरियो पत्ता लिएर बस्ने बिचार भए प्रोग्रामिङ्गमा दह्रो बन्नु पर्छ भन्ने सुझाब दिएको होला Radhakrishnले ?
अर्ति भन्ने कुरा मिठो हुन्न : अनि अरुलाई Parental Advise गर्न पनि हुँदैन : गरेको नतिजा तिमीहरु दुवै गालि गलौज मा पुग्यौ | आफ्नो आफ्नो कर्म को फल भोग्नु पर्छ | म पनि भोगी रहेको छु ( I did not take the advise).

Last edited: 14-Nov-15 07:40 AM

 
Posted on 11-14-15 8:13 AM     [Snapshot: 235]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

मगोर्खे जिउ, तपाइको कुरा किन सधै छेउ न टुप्पोको हुञ्छ ? आफु पनि त advice दिनु भै रहेको छ | राधाकृष्ण जिउ लाइ चाहि advice दिएको मा criticize गर्नु हुञ्छ |
 
Posted on 11-14-15 10:40 AM     [Snapshot: 298]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

cp21: leave everything behind... focus on one thing... how to find your father....

Again, DID YOU ASK YOU MOTHER WHO YOUR FATHER IS....???
 
Posted on 11-14-15 12:21 PM     [Snapshot: 332]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Here's the fiddle

http://sqlfiddle.com/#!6/9eecb7db59d16c80417c72/187


DECLARE
@PRICE INT = 100,
@TAXRATE FLOAT = 0.07,
@TAXAMOUNT FLOAT
SET @TAXAMOUNT = @PRICE * @TAXRATE
SELECT
@PRICE AS 'PRICE',
@TAXRATE AS 'TAX RATE' ,
@TAXAMOUNT AS 'TAX AMOUNT',
@PRICE + @TAXAMOUNT 'TOTAL PRICE'


Hope it helps
 
Posted on 11-15-15 1:53 AM     [Snapshot: 458]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

@ cp21:

हैन मारिस कि क्या हो CP21 ??? खबर त केहि छैन त ? कि बाउ भेटिस तहिले ??? अनि बाउ ले तेरो chak मा निल दाम आउन्जेल कोर्रा बोर्साए र तेरो दिमाग ठिक ठाउँ मा आएको हो ??? Did you learn manners now??? Have you become a man! कि छक्का नै होस् जसको बाउ को अझ अत्ता पत्ता छैन ??


 
Posted on 11-15-15 1:55 AM     [Snapshot: 459]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Forgot to ask:::

DID YOU ASK YOUR MOTHER WHO YOUR FATHER IS???
 
Posted on 11-15-15 12:42 PM     [Snapshot: 536]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Thanks mero nam ho for providing your logic.. Now I can apply this logic if i encounter any issues going forward..



 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 7 days
Recommended Popular Threads Controvertial Threads
मन भित्र को पत्रै पत्र!
TPS Work Permit/How long your took?
Does the 180 day auto extension apply for TPS?
Travelling to Nepal - TPS AP- PASSPORT
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters