Their are many approaches to get alternate record from SQL server database table. Here i have discussed 2 approaches1. Complex Query2. Using Views Complex...
Without DataSelect * INTO tbem1 from tbemp where 1=2 Why 1=2?Because none of the record could satisfy this condition i.e. 1=2. So no data...
Get duplicate records from tableSelect ename from tbemp a where a.eno!=(select Max(eno) from tbemp b where a.ename=b.ename) Here eno denotes to employee number and...
Union is to select all records from two table but common record only once. Select * from tbemp1UNIONSelect * from tbemp2 Inersect is to select common...