Question Of The day 09 Nov : Find Out the output for given SQL Statement.

Question No: 1

A Relation Schema (Table1) is given below

EmpID                    Salary
  1                    	  10$
  2             	  20$
  3            	          30$
  4           		  Null

The Following Sequence of SQL Statement executed successfully on Table1.
UPDATE Table1 SET Salary = Salary + 5;
SELECT AVG(Salary) FROM Table2;
What will be the output of the SELECT Statement.
1)  25$
2)  18.75 $
3)  20$
4)  80/3 $

Give Answer In comment
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s