Interested to Buy Any Domain ? << Click Here >> for more details...
In one table there is 10 records without id num,without
primary key and it is not sorted then how to extract last 6
record from table?
- 4 Answers
- 9020 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
CREATE TABLE Sample
(
Col1 varchar(5)
)
insert into Sample values('j')
TABLE:
Col1
j
r
c
r
e
f
g
h
x
j
USING CURSOR: ANSWER
DECLARE @COL1 VARCHAR(5)
DECLARE @COUNT VARCHAR(5)
SET @COUNT=0
DECLARE c1 CURSOR
FOR
SELECT COL1 FROM SAMPLE
OPEN C1
FETCH NEXT FROM C1
INTO @COL1
WHILE @@FETCH_STATUS=0
BEGIN
SET @COUNT=@COUNT+1
IF @COUNT>=5
BEGIN
SELECT @COL1
END
FETCH NEXT FROM C1
INTO @COL1
END
CLOSE C1
DEALLOCATE C1
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / laxman
select * from table_name limit 6;
above query is wrkg in mysql
ex;
select * from emp limit 6;
this one is upto 6
u want 10 limit 10 ;
thts ur choice
select * from emp columnname limit 6;
ok
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sunil soni
CREATE TABLE Temp(
Col1 varchar(5)
)
insert into Temp values('j')
TABLE:
Col1
j
r
c
r
e
f
g
h
x
j
select top 6 col1 from (select row_number() over(order by
id) as rowid,name from (select rand() as id, name from
@temp) t ) t1 order by t1.rowid desc
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / rangaraj
create table empmaster(ename varchar(34))
insert into empmaster values('r')
select * from empmaster
Query:
select top 6 (ename) from empmaster order by ename desc
| Is This Answer Correct ? | 2 Yes | 4 No |
In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?
What severity level errors are managed in TRY-CATCH block?
Is the company liable to deduct professional tax of directors?
when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.
When do you get "getwmicomexception"?
When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.
What is the use of NOLOCK locking hint?
i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.
today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql
How will you Handle Error in SQL SERVER 2008?
What is SCD (Slowly Changing Dimensions)? What are its types?
Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??
Oracle Errors 
