Write a code to select distinct records without using the DISTINCT keyword.
No Answer is Posted For this Question
Be the First to Post Answer
Can we execute a stored procedure inside a trigger?
6 Answers BirlaSoft, CarrizalSoft Technologies, United Healthcare,
What is difference between table aliases and column aliases? Do they affect performance?
How to receive output values from stored procedures?
What is the data type of time?
What happens if null values are involved in bitwise operations?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is normalization according to you and explain its different levels?
How to use clusters?
What is inline table-value user-defined function?
Describe in brief databases and sql server databases architecture.
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
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)