How to select unique records from a table?
No Answer is Posted For this Question
Be the First to Post Answer
What is nvl function?
Where not exists in sql?
What company owns postgresql?
What is dynamic query?
how will be date change into string
What is indexing oracle sql?
How do you retrieve the second highest salary from a table?
How to get help at the sql prompt?
Types of joins?
I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.
Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
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)