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 19139i 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,
11 13596Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
14 31403There 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 9417
What is sql comments?
Is sql a oracle?
What is the purpose of a sql?
What is procedure in pl sql?
What is nvarchar in sql?
How do I write a sql query in pgadmin 4?
How can a pl sql block be executed?
What is data profiling in sql?
Why is nosql good?
Is pl sql better than sql?
How bulk collect improves performance?
Does truncate require commit?
What is a column in a table?
Can dml statements be used in pl/sql?
What is a pl/sql block?