Given a table SALARIES, such as the one below, that has
m = male and
f = femalevalues. Swap all
m values (i.e., change all
f values to
m and vice versa) with a single update query and no intermediate temp table.
Id Name Sex Salary 1 A m 2500 2 B f 1500 3 C m 5500 4 D f 500
- Jeff answered 2 years ago
I have been asked to explain what Primary key and Index are and to write a simple query. You also might be ask to explain the different types of JOIN and Having or Group by. Basically, you shouldn't be stressed about the SQL questions if you know the basics.