how to sort records in sql?3 4931
write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 200006 16877
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)14 24925
Write a query to find five highest salaries from EMP table. (there is a column SALARY)23 36928
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
how can create data base link for tow servers (scott schema) give examples plz2 3536
using comand prompt how can import table data and table space with example2 3802
What is difference between sql and excel?
What is a recursive join sql?
What are the types of subqueries?
How to move files from one directory to another in pl sql?
what is 'trigger' in sql? : Sql dba
Explain character-manipulation functions?
What is the function that is used to transfer a pl/sql table log to a database table?
How to add new employee details in an employee_details table with the following details
Can we group by two columns in sql?
How do sql databases work?
what are enums used for in mysql? : Sql dba
How does index help in query performance?
what is check constraint? : Sql dba
what is not null constraint? : Sql dba
What operators deal with null?