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 20000
6 22782i 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
IBM,
12 20306Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
15 41506There 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 ?
IBM,
4 11567
what is a materialized view? : Sql dba
What is the difference between sql, mysql and sql server?
Is mariadb a nosql database?
What is the use of double ampersand (&&) in sql queries? Give an example
Write a sql query to find the names of employees that begin with ‘a’?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is constant in pl sql?
what is innodb? : Sql dba
What can I use instead of union in sql?
What is a heap in sql?
Can you inner join the same table?
What is pl sql package?
Explain clause in sql?
What is hibernate and its relation to sql?
Why schema is used in sql?