- View - Base TablesDoes View occupy memory? If we delete the base table of existing view, What happens?
- HAVING vs WHERE ClauseWhere clause restricts rows, what does having clause restricts ?
1. only group results.
2. rows results.
3. both rows and groups result.
- how many columns can be in the group by clause
- write a query to update third column such thatThere is a table having the following columns :-
student id marks1 marks2 maxmarks
1 10 20 20
2 25 30 30
3 30 10 30
4 35 25 35
5 20 40 40
write a query to update column maxmarks such that maxmarks column contains
whatever be the greater value among marks1 and marks2 columns ( as shown in table ).
- Data ConversionHave 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: Last
Table Name :Emp1
Table Name: Emp2
Need to write a SQL query to convert the data from Emp1 to Emp2 in this way.
Can any body help me.
You must first Login or Register to view all 170 questions from this category.
Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.