need statement without FROM clause

Archived from the original Sajha.com — preserved as posted, replies can no longer be added here.

Archived Post

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

cp21 · Nov 11, 2015 9:23 PM · 19,505 views

8 Replies

I am Back!

RadhaKrishna · Nov 12, 2015 2:20 AM

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

Magorkhe1 · Nov 14, 2015 7:38 AM

मगोर्खे जिउ, तपाइको कुरा किन सधै छेउ न टुप्पोको हुञ्छ ? आफु पनि त advice दिनु भै रहेको छ | राधाकृष्ण जिउ लाइ चाहि advice दिएको मा criticize गर्नु हुञ्छ |

nepalnepaliko · Nov 14, 2015 8:13 AM

cp21: leave everything behind... focus on one thing... how to find your father.... Again, DID YOU ASK YOU MOTHER WHO YOUR FATHER IS....???

RadhaKrishna · Nov 14, 2015 10:40 AM

Here's the fiddle http://sqlfiddle.com/#!6/9eecb... 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

mero_naam_ho · Nov 14, 2015 12:21 PM

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

RadhaKrishna · Nov 15, 2015 1:53 AM

Forgot to ask::: DID YOU ASK YOUR MOTHER WHO YOUR FATHER IS???

RadhaKrishna · Nov 15, 2015 1:55 AM

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

cp21 · Nov 15, 2015 12:42 PM

This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.

Start a New Discussion