sybase sql questions...
Posted on 2006-06-14
have some SQL questions please just to get more understanding...
1). I have a EMP table -- I want to get all the rows which are equal .. what is the query for this?
2). I want to get a employee which is 3rd in the salary range?
3). I want to insert a column into this table which is a primary key and has distinct values (many be just count from 1......)
I want to insert a column
empId empName empSalary
and update table by populating empId column with distinct numbers...
4). In sybase -- there is something like internal deleted and inserted tables -- what are those? and how to read them?
5). what are temp tables in sybase? where do we use them?