How to locate and take substrings with charindex() and substring() functions?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between dataadapter and datareader?
what operator performs pattern matching?
How to verify a user name with sqlcmd tool?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
how many type of subquery?
What is dirty read?
What is subquery in sql?
Explain an automatic checkpoint
Define outer join?
Explain syntax for viewing trigger?
Can group functions be used in the order by clause in ms sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)