need statement without FROM clause

Posts 9 · Viewed 9512 · Go to Last Post

· Snapshot 0

Like · Likedby · 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

RadhaKrishna

· Snapshot 75

Like · Liked by · 0

I am Back!

magorkhe1

· Snapshot 216

Like · Liked by · 0

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

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

nepalnepaliko

· Snapshot 235

Like · Liked by · 0

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

RadhaKrishna

· Snapshot 298

Like · Liked by · 0

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

Again, DID YOU ASK YOU MOTHER WHO YOUR FATHER IS....???

mero_naam_ho

· Snapshot 332

Like · Liked by · 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

RadhaKrishna

· Snapshot 458

Like · Liked by · 0

@ cp21:

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

RadhaKrishna

· Snapshot 459

Like · Liked by · 0

Forgot to ask:::

DID YOU ASK YOUR MOTHER WHO YOUR FATHER IS???

cp21

· Snapshot 536

Like · Liked by · 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 reply to this post

You can also log in using your Facebook