Query to display string in vertical form
INPUT WELCOME OUTPUT The Query
0 Comments
October 4, 2020
Turning a Comma Separated string into individual rows
Sample Table CREATE TABLE Testdata ( SomeID INT, OtherID INT, String VARCHAR(MAX) ) INSERT Testdata SELECT 1, 9, '18,20,22' INSERT Testdata SELECT 2, 8, '17,19' INSERT Testdata SELECT 3, 7,…
October 4, 2020
Find out last 4 rows inserted rows ?
Retrieve data from emp table Emp table find out the last last 4 rows inserted
October 4, 2020
sql – how to split full name into first and middle and last name
If I have a table with a column that contains fullnames such as : select * from name table; name table IDNAME101sachin ramesh tendulkar102virat koholi103rabi sastri104thakur ramesh kar105pratap ram sek…
October 3, 2020
Find out in which year maximum number of employee has been recruited ?
Retrieve data from emp table The Query select to_char(hiredate,'yyyy'),count(*) from emp group by to_char(hiredate,'yyyy') having count(*)>=(select max(count(*)) from emp group by to_char(hiredate,'yyyy')) ;
October 2, 2020
SQL-Find the unique records from two tables ?
Q. Table_ASl_no1234 Table_BSl_no12 output should be only 3&4 without using minus or exists just using left join . left join minus output SQL- query to find out the distinct values…
October 2, 2020
Retrieve the department number and salary ‘s duplicate records From emp-table ?
Retrieve data from emp table i.e How many duplicate records are present (department and salary wise) in emp-table
October 2, 2020
Display the all employee details whose having duplicate salary
We are retrieve the records from emp table. or output on tool
October 2, 2020
Find out 2nd highest salary
Using dense_rank Using row_number 2nd highest salary output on tool Retrieve 2nd highest salary from emp table 3rd highest salary using densk_rank Select * from (select dense_rank() over(order by…
October 2, 2020