July 29, 2014
One tricky question asked in interview on Having and group by Clause
select * from EmployeeSalary order by id
--o/p [Need employee id and the count that crossed more than 5000]
--employeeid and count(>...
Tuesday, 29 July 2014
July 29, 2014
A nice way to truncate all the tables
I wanted to truncate all tables in a cursor. But I was unable to do it as some table were being reference by foreign key constraint.
This is the...
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.